SQL Reference

1.{{ $index + 1 }}. {{ r.Name }}

2.{{ $index + 1 }}. {{ r.Name }}

3.{{ $index + 1 }}. {{ r.Name }}

4.{{ $index + 1 }}. {{ r.Name }}

5.{{ $index + 1 }}. {{ r.Name }}

Insert Row
6.{{ $index + 1 }}. {{ r.Name }}

Replication

8.{{ $index + 1 }}. {{ r.Name }}

9.{{ $index + 1 }}. {{ r.Name }}

10.{{ $index + 1 }}. {{ r.Name }}

11.{{ $index + 1 }}. {{ r.Name }}

data/ref

I want to... ...delete a column

Parameter Sniffing
1. replace parameters with local variables
2. WITH RECOMPILE

SET STATISTICS IO ON
SET STATISTICS IO OFF
----------------------
ORDER BY 
    case when (@Condition1 = 1) then Column1 end,
    case when (@Condition1 = 2) then Column2 end desc
----------------------
* nolock
* parameter sniffing
* indexes
* refactoring
* API tables
----------------------
* left join is safe only if the RHS has unique records. Otherwise the LHS will repeat.
----------------------
DDL   Data Definition Language       create table, alter table
DML   Data Manipulation Language     CRUD
DCL   Data Control Language
TCL   Transaction Control Language
----------------------