Ten Query Tuning Techniques Every SQL Programmer Should Know - Kevin Kline

Note: This is an online meeting. The link to the meeting will be visible once you RSVP.

Ten Query Tuning Techniques Every SQL Programmer Should Know - Kevin Kline

SELECT statements have a reputation for being very easy to write, but hard to write very well. This session will take you through ten of the most problematic patterns and anti-patterns when writing queries and how to deal with them all. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries from mundane to masterful. Learn how to assess query performance, guarantee consistent query tuning, and avoid ten all-too-common performance killers in SELECT statements running on Microsoft SQL Server.

Goal 1: Implement a reusable Transact-SQL test harness for reliable query results.
Goal 2: Learn ten patterns that kill the performance of SELECT statements and how to avoid them.
Goal 3: Discover the high-impact metadata that shows how a SELECT statement behaves... or misbehaves.

Kevin Kline is a noted database expert and software industry veteran. A long-time Microsoft Data Platform MVP and noted community leader in the IT industry, Kevin is a founder and former president of the Professional Association for SQL Server, as well as the author of popular IT books like SQL in a Nutshell. Kevin is a top-rated speaker at industry trade shows worldwide and has a monthly column at Database Trends magazine. He tweets at @kekline and blogs regularly. Kevin is a Principal Program Manager at SentryOne, a leading vendor of database tools.

Meeting Sponsor:
SentryOne
https://www.sentryone.com/

Sacramento SQL Server User Group:
https://www.meetup.com/Sacramento-SQL-Server-User-Group
https://sac.pass.org
https://twitter.com/sacsqlug
https://www.linkedin.com/groups/2825448