webcast signup header

Improving SQL Server Queries by Reading and Understanding Execution Plans


Before SQL Server executes a query, it generates an execution plan. Some plans are trivial, such as returning all the rows from a single table. However, when we go beyond the simplest of cases, SQL Server generates a "good enough" execution plan to accomplish the work. It'll use the indexes we've created, the statistics on those indexes, as well as how we’re manipulating the data based on the query to determine that execution plan. The hardware and the amount of data determine how fast the query returns.

If a query is performing poorly, there’s a lot within our control to improve performance. The key to doing so is understanding the execution plan.

In this webinar we'll cover how to use the tools SQL Server provides us to capture execution plans. We'll then walk through how to read an execution plan and how to use that information to write better queries. We'll discuss the impact of outdated statistics, improper indexing, and look at examples of T-SQL anti-patterns which cause our queries to run poorly. Finally, we’ll work through some remediation examples of those performance killers so you’ll have some tools with which to attack poorly performing queries in your own environment.

Webcast Date

Thursday, October 03, 2019
1:00:00 PM EDT | 5:00:00 PM UTC

Speaker(s)

presenter 1
Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), and former Microsoft Data Platform (SQL Server) MVP (2009-2016) focusing primarily on SQL Server and Windows security. Brian currently serves as a data architect as well as an independent infrastructure/security architect concentrating on Active Directory, SQL Server, and Windows Server. He has served in a myriad of other positions including senior database administrator, data warehouse architect, web developer, incident response team lead, and project manager. Brian has spoken at 24 Hours of PASS, IT/Dev Connections, SQLConnections, the Techno Security and Forensics Investigation Conference, the IT GRC Forum, SyntaxCon, and at various SQL Saturdays, Code Camps, and user groups.

Sponsored by

sponsor logo


Register for this webinar:

First Name*


Last Name*


Business Email*


Organization*


Org Address*


Org City*


Org State


Org Postal Code*


Org Country*


Org Phone*


Industry*


Job Title*


# of SQL Servers*


Organization Size*


SMS reminder
carrier: number: (5551234567)


Save My Details

Register me for these webinars too:

 
Troubleshooting Performance Issues with SQL Server Agent
Tuesday, September 17, 2019 - 3:00:00 PM EDT
Speaker(s): K. Brian Kelley and Louis Diaz-Delgado - Sponsor: MVP Systems

 
SQL Server on AWS Cloud: One Customer's Journey and Experience
Thursday, September 19, 2019 - 1:00:00 PM EDT
Speaker(s): Dave Bermingham and Tom Staab - Sponsor: SIOS

 
Keep SQL Server’s Always On Running Smoothly
Tuesday, September 24, 2019 - 3:00:00 PM EDT
Speaker(s): Rey Rios - Sponsor: IDERA

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


 

 


Copyright (c) 2006-2018 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.