IN THIS PART
It seems everyone wants a quick fix.
On one optimization job, I identified and prioritized numerous issues with the schema, queries, and indexes that together would have reduced the aggregate workload by 60–80 percent. I thought I'd done a great job. The client didn't think so. They actually said they were hoping that as an MVP I'd know of an undocumented "go fast" switch.
The switch is in the design!
But once the schema and queries are right and the workload is known, it's time to tune the indexes and optimize the server. From reading query execution plans, to query paths and indexing, to data compression, this part is filled with some of my favorite SQL Server topics. If you thought left outer joins were fun, well, you're in for a real treat.
If SQL Server is the box, this part is about making the box scream.