Next Meeting: Mon, Jan 28 2013

January 2013 user group meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: None

Performance Tuning – Analyzing Query Execution Plans  
Presented by Konstantin Melamud 


This topic will provide a more in depth look into query execution plans and is targeted for junior to senior DBA’s. You will learn how to identify what indexes are being used by the SQL optimizer, different type of index operations that are performed by SQL server and what operations are generally considered as a preferred method of data retrieval. We will discuss how to determine if indexes used by the optimizer are the optimal ones and the exceptions to the rules. Finally we will discuss the relationship between different types of index operation and different types of join types within SQL Server including how the SQL Optimizer determines which join type it will use and pros and cons of each type.  

Konstantin Melamud is a SQL Server Team Lead for Remote DBA Experts. He works with over 200 customers on solutions within the SQL Server environment and leads code tuning team within Remote DBA experts. He is passionate about educating users on SQL Server by speaking at user groups, conferences, and labs. 

When

iCal
UTC : Mon, Jan 28 2013 20:00 - 22:00
Event Time : Mon, Jan 28 2013 15:00 - 17:00 (UTC-05:00) Eastern Time (US & Canada)
Your Local Time: Mon, Jan 28 2013 20:00 - 22:00

Where

Pittsburgh North Shore
Pittsburgh, Pennsylvania

Direction: None

Attachments