CTE and more

normalization/denormaliztion
fact/dimension/base
staging
cursor ( performace killer )
CTE
WITH
Hierarchical data
HierarchyID data type
recursive tree
window function
analytical function
aggregate function
ranking function
performance tuning (SET NOCOUNT ON)
random data or data sample (TOP n, TABLESAMPLE(n ROWS), ORDER BY NEWID( ), CHECKSUM(NEWID())
CASE
IDENTITY AND MONEY data type
ALTER (no modify in SS), UPDATE
DELETE, TRUNCATE
DROP (reference)