Conor Cunningham
Conor serves as an architect for the SQL core database engine at Microsoft. He has worked for Microsoft for over 20 years building database engines and has worked on a variety of features over numerous product releases.
SQLBits 2011
Update Queries-Deep Dive
Ever wanted to know exactly what is happening underneath the covers in your queries. Let me show you.
This talk will cover how to read and understand all of the things that happen during the optimization and execution of insert, update, delete, and merge queries. You’ll be able to understand all of the exotic operators you see in update plans, how various features you use impact the work updates need to do, and let you go to the next level when debugging your query plans.