Details

SQL Server Internals: It's What's for Dinner!

Speaker: Christina Leo

Duration: 60 minutes

Track: Virtual/remote

Ever wondered what happens under the hood when you query your SQL Server database? Well, it’s somewhat like asking for a special meal for dinner. During this session, I will use a cooking analogy to describe the life cycle of a query and the journey it takes through SQL Server’s working parts. By comparing the concepts of SQL Internals to a familiar idea, you will have a clear understanding of the underlying processes involved in returning data from a SELECT query. Once we’ve established a frame of reference for a simple read operation, we’ll look at an UPDATE statement and consider the additional factors associated with a write operation.  By session's end you should have a clear overview of what happens when a query hits your server.

Accompanying Material

No material found.


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids