Here I will post resources and dicussions regarding SQL Server performance tuning and optimisation.
Structural/Design Focused Optimisation
- All about the tempdb database
- SQL Server 2005 Row Versioning Snapshot Isolation
- Automatic Index Defragmentation Script
- Non Clustered Index – Tipping Point
- Statistics Used by the Query Optimizer
- Creating New Datawarehouse Filegroups
- Evaluating Rows Per Data Page and Fill factor
Query Specific Optimisation
- All about Execution Plans
- Forcing Query Plans
- Batch Compilation, Recompilation and Plan Caching Issues in SQL Server 2005
- Issues to be aware of when using Common Table Expressions (CTE’s)
- Scalar functions, inlining, and performance – Adam Mechanic shows how Table Valued UDF’s can be leveraged to performance optimize scalar UDF’s
- NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: SQL Server
- Last Word On Scans
Troubleshooting Performance
- SQL Server Wait Type Explanation
- SQL Server 2005 Diagnostic Queries
- Performance Tuning Waits and Queues
- PAL – A nifty tool for anylysing PerfMon data.
Misc