Faster, faster! We all want our queries to run faster, but what are we 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.
Andy Warren is a SQL Server consultant based in Orlando. Andy was a founding principal of SQLServerCentral.com, is the former President of the Orlando SQL Server Users Group, and one of the founders of SQLSaturday. He has been an MVP since 2009 and has written and presented extensively SQL Server. Andy blogs at www.sqlandy.com, is on LinkedIn at www.linkedin.com/in/sqlandy, and is occasionally on Twitter as @SQLAndy.
Topics: Database Administration, Database Security, SQL Query Performance Products: DBArtisan