Learn more about SQL Server tools

mssqltips logo
giveaway
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Making SQL Server Queries Run Faster

Sponsored by - IDERA

Webcast Abstract

Faster, faster! We all want our queries to run fast, but what are supposed to do to make that happen?

This presentation is about approaching query writing and tuning as a repeatable process. We'll start with some basic rules for writing good queries. From there we'll see how to measure the actual performance of the query in reads and duration, the best way to evaluate OLTP type queries. With a baseline determined for our query we can then review the query plan for the five most common causes of slow performance, make the relevant tuning fix, and then re-execute the query to see if we made things better or not.

Speaker - Andy Warren

Andy Warren is a SQL Server DBA in Orlando that focuses on administration and helping teams leverage SQL as a platform.

To access materials please fill out the form below.



































By submitting this data you are accepting to receive newsletters, account updates and special offers about SQL Server from MSSQLTips and our sponsors. We respect your privacy and you can unsubscribe at any time.



More SQL Server Solutions











Learn more about SQL Server tools