O'Reilly logo

Microsoft® SQL Server® 2008 Bible by Uttam Parui, Mike White, Paul Nielsen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Part IX. Performance Tuning and Optimization

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required