T-SQL Performance Tuning for Race Car Drivers
T-SQL Performance Tuning for Race Car Drivers
Times are tough even for the best drivers: Helio Castroneves is dancing for money and Danica Patrick is doing ads for what appears to be an adult services company. Maybe it’s time to switch careers, and Brent has just the thing. Use your hard-earned knowledge of high speeds, million-dollar hardware and surviving disastrous crashes to become a SQL Server performance tuner!
In this one-hour video recorded at the SQLBits 2009 conference, Brent will show you:
- Why Colin Chapman would check for indexes before adding new ones
- The importance of well-tested safety gear to performance tuning
- Why not monitoring your servers is like overdriving your headlights
- Just like races are lost in the pits, uptime records are lost during maintenance windows