Webcast : Making SQL Server Queries Run Faster
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.
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.
Manage multiple DBMS platforms from one UI.
- Proactively manage space, data and performance
- Move schema and table data across platforms
- Easily find and fix performance issues
- Protect data security