Explore all the products and find the right solution for your business
Proactively manage server performance on-prem or in the cloud with timely alerts and analytics
Fast configuration of regulatory and audit compliance settings with proactive monitoring, alerts, and reporting
Automated database security, monitoring and management for MS SQL, Azure and Amazon RDS for SQL Server
Backup and instant recovery for SQL Server, Azure Blob Storage and Amazon S3
Discover, track and manage database inventory across the entire environment
24 Essential tools to simplify daily server administration
Get the right solution to keep your database running at peak performance.
All of the support you need at your convenience.
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