Explain Codes LogoExplain Codes Logo

Sql

Scope of temporary tables in SQL Server

sql
performance
best-practices
sql-server

Postgresql INSERT FROM SELECT RETURNING ID

sql
prompt-engineering
best-practices
performance

Sql Server: how to add new identity column and populate column with ids?

sql
identity-column
data-integrity
sql-performance

Variable Value Assignment Using RETURNING Clause

sql
best-practices
error-handling
sql-operations

How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access

sql
sql-injection
prepared-statements
exception-handling

How do I force Postgres to use a particular index?

sql
database-statistics
index-optimization
query-planner

How can I include null values in a MIN or MAX?

sql
null-values
min-max-aggregation
sql-queries

How do I decrease the size of my sql server log file?

sql
log-management
database-administration
performance-optimization

Is it necessary to use # for creating temp tables in SQL server?

sql
temp-tables
table-variables
sql-performance

How can I alter this computed column in SQL Server 2008?

sql
data-types
sql-server
computed-columns

Can there be constraints with the same name in a DB?

sql
best-practices
database-design
constraint-naming

Can a foreign key refer to a primary key in the same table?

sql
database-normalization
self-referencing-keys
foreign-key

Insert with SELECT

sql
data-transformation
sql-functions
database-management

Script entire database SQL-Server

sql
scripting
database-management
sql-server

Don't update column if update value is null

sql
best-practices
performance
null-management

Why no windowed functions in where clauses?

sql
window-functions
sql-best-practices
query-optimization

Postgresql: INSERT INTO ... (SELECT * ...)

sql
performance
best-practices
sql-injection

Select n random rows from SQL Server table

sql
performance
randomness
sampling

How to Check for is Not Null and is Not Empty String in SQL Server?

sql
best-practices
performance
data-variants

Mysql Select rows on first occurrence of each unique value

sql
window-functions
mysql-8
performance
explain.codes / Sql