Sql

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

backup-strategy

database-restore

Create a Cumulative Sum Column in MySQL

window-functions

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

foreign-key-constraints

database-performance

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

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

Language SQL vs LANGUAGE plpgsql in PostgreSQL functions

database-optimization

function-design

sql-performance

Sql Update from One Table to Another Based on ID Match

Remove uniqueness of index in PostgreSQL

database-management

index-management

How do I find records that are not joined?

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

bitwise-negation

performance-tips

Postgres Case Sensitivity

database-migration

case-sensitivity

Including parameters in OPENQUERY

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

identity-insert

In SQL / MySQL, what is the difference between "ON" and "WHERE" in a join statement?

Sql JOIN vs IN performance?

join-performance

query-optimization

Best way to get result count before LIMIT was applied

count-operations

Insert the same fixed value into multiple rows

database-management

Mysql Multiple Joins in one query?

List names of all tables in a SQL Server 2012 schema

database-optimizations

Increasing the Command Timeout for SQL command

sql-performance

query-optimization

explain.codes / Sql