Debugging without debugger: investigating SQL Server’s internal structures

This page contains the description for my conference session “Debugging without debugger: investigating SQL Server’s internal structures”.

Description

Target audience Experienced database developers and DBAs, plus all curious geeks.
Short description A fast paced overview of tricks and methods that can be used to peek into internals of SQL Server, without having to use a debugger tool.
Duration The ideal length for this session is 60 – 75 minutes.
Full abstract Have you ever wanted to know exactly how SQL Server stores data for temporary structures, such as for instance the spooled data in a Table Spool or Index Spool operator? No? I don’t blame you. It’s a bit like wanting to know who watered the rubber tree that produced the rubber your tires are made off before you get in the car to drive to work. You really don’t need it.
But you might still WANT to know. I did. And I figured it out.
Without ever touching the debugger (I’m a simple soul, that stuff is much too complex for me!), I figured out how I could look at the exact storage structures SQL Server creates and uses to store data in Table Spool and Index Spool operators.
If you are willing to commit to a fast-paced and deep internals session that is guaranteed to teach you exactly zero actually useful information, then this is the session for you.

Resources

This session has not yet been presented. I am still working on the slide deck and the demos, and will probably continue to do so until shortly before it is first presented. The “final” version of the slide deck and demo code will be uploaded here around the time I first deliver this session.

Menu

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close