Update Queries-Deep Dive
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.
Conor Cunningham is a Principal Software Architect at Microsoft on the SQL Server Query Processor Team. He's worked on database technologies for Microsoft for over 10 years and is holds numerous patents related to Query Optimization and Query Processing. Conor is the author of a number of peer-reviewed articles on query optimization techniques. Recently, he authored a chapter for the book "Microsoft SQL Server 2008 Internals" on how the Query Optimizer works. He publishes a blog called "Conor vs. SQL" (http://blogs.msdn.com/conor_cunningham_msft/default.aspx
) where he answers questions about databases.