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

• Creating Test Data