SQL Performance Tips

This presentation addresses some high-level performance tuning options for SQL Server queries.

Slide deck: PowerPoint (384KB) or PDF (419KB)

Demo scripts: ZIP (3KB)

Topics addressed in this session

  • Execution plans
  • “SARG”ability
  • Temp tables vs. table variables
  • Intermediate materialization
  • Window functions
  • Locking in SQL Server
  • “Kitchen Sink” procedures