Explain Codes LogoExplain Codes Logo

Sql

How big is too big for a PostgreSQL table?

sql
database-maintenance
data-partitioning
indexing

Use tnsnames.ora in Oracle SQL Developer

sql
tnsnames.ora
oracle-sql-developer
environment-variables

Grouping timestamps by day, not by time

sql
date-functions
performance-optimization
aggregation

Postgresql: how to convert from Unix epoch to date?

sql
timestamp
date-conversion
postgresql

Postgresql calculate difference between rows

sql
prompt-engineering
best-practices
dataframe

Must declare the scalar variable: *How to Rid Your Code of this Pesky Error*

sql
sql-injection
dynamic-sql
variable-declaration

Increment Row Number on Group

sql
dense-rank
row-number
materialized-views

The tail of the log for the database "DBName" has not been backed up

sql
backup-strategy
database-restore
sql-server

Create a Cumulative Sum Column in MySQL

sql
cumulative-sum
mysql
window-functions

What are practical differences between `REPLACE` and `INSERT ... ON DUPLICATE KEY UPDATE` in MySQL?

sql
foreign-key-constraints
database-performance
data-integrity

Why do I get "Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'." when I try to use sp_executesql?

sql
sql-server
dynamic-sql
nvarchar

In a join, how to prefix all column names with the table they came from

sql
dynamic-sql
column-aliases
sql-injections

Language SQL vs LANGUAGE plpgsql in PostgreSQL functions

sql
database-optimization
function-design
sql-performance

Sql Update from One Table to Another Based on ID Match

sql
update
join
merge

Remove uniqueness of index in PostgreSQL

sql
database-management
postgresql
index-management

How do I find records that are not joined?

sql
join
best-practices
performance

Boolean 'NOT' in T-SQL not working on 'bit' datatype?

sql
bitwise-negation
sql-queries
performance-tips

Postgres Case Sensitivity

sql
best-practices
database-migration
case-sensitivity

Including parameters in OPENQUERY

sql
sql-injection
dynamic-sql
sp_executesql

How to insert into a table with just one IDENTITY column?

sql
identity-insert
default-values
sql-server
explain.codes / Sql