One single inefficient query can have disastrous effect on your SQL Server performance. It can overload all the processors preventing other processes from executing efficiently. This is a session for every Developer, DBA working with SQL Server which provides you with the nuts and bolts of SQL Server Query Execution Plans and how to analyze them. This session will drill in to the Architecture of Query Processing, Operators and Iterators in Execution plans, Basic Operators, Seek vs. scans, Joins-Merge Vs Hash Vs Nested Loop which will help you tune and optimize your SQL Server performance.
Presenters: Sivaram Annadurai & Roji P Thomas
(less)