Make SQL Server Queries Go Faster

Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? In this session you will learn some T-SQL performance tuning tips that can be applied on Monday back at the office. You will learn how to identify top offender queries, be able to benchmark queries, and apply proper indexes while avoiding common mistakes. Finally we will cover coding patterns that are developer friendly but are not SQL Server database engine friendly and show you how to rewrite them so they can run faster.

John Sterrett is a Group Principal and Sr. Consultant at Linchpin People. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a PASS Regional Mentor, leader of the Austin SQL Server User Group and founded High Availability and Disaster Recovery Virtual Chapter.