Geek Sync Webcast : How To Think Like The Engine

Presenter: Brent Ozar

When you pass in a query, how does SQL Server build the results? I will give you a scenario: I’m the end user sending in queries, and the SQL Server engine is my client. Using simple spreadsheets as tables, you’ll learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This session is for DBAs and developers who are comfortable writing queries, but not so comfortable when it comes to explaining nonclustered indexes, lookups, sargability, and fill factor.

About Brent Ozar

Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz® and sp_AskBrent®, coauthored Professional SQL Server 2008 Internals and Troubleshooting, and he loves sharing knowledge at BrentOzar.com. He’s a Microsoft Certified Master of SQL Server.

Topics : Database Diagnostics,Database Monitoring,Database Performance,SQL Query Performance,

Products : SQL Diagnostic Manager for SQL Server,

Register for Free Webcast

Note: By registering, you confirm that you agree to the processing of your personal data by Idera, Inc. as described in the Privacy Statement.
Idera, Inc. is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.