SQL query optimization — How to determine when and if it’s needed
SQL query optimization is no easy feat. Ensuring it’s the right solution to the right problem is key. Learn what to look for and who to listen to.
Brent Ozar explains SQL Server internal and external fragmentation
Read Brent Ozar's hard-earned wisdom on SQL Server internal and external fragmentation.
SQL Server tuning – it’s all about measurement
Brent Ozar reminded us that database performance is all about measurement in his training session on “How to Measure SQL Server,”