Articles and notes covering all aspects of SQL, its use, commands and related infrastructure.
- SQL Server CTE Basics
NOLOCKS & performance
- Never mind the NOLOCKS
- The 7 Sins against SQL Performance
Couple of excellent articles from PurpleFrog giving and introduction to MERGE:
- Excellent introduction to basics of the MERGE statement from PurpleFrog and then taking you further in to the use of MERGE with Slowly Changing Dimensions:
- Another excellent article covering much the same material: