Debugging without debugger investigating SQL Servers internal structure

Published: 02 June 2023
on channel: EightKB

508

Hugo Kornelis - Debugging without debugger: investigating SQL Server's internal structures

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 wattered 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 high-level internals session that is guaranteed to teach you exactly zero actually useful information, then this is the session for you.

On this page of the site you can watch the video online Debugging without debugger investigating SQL Servers internal structure with a duration of hours minute second in good quality, which was uploaded by the user EightKB 02 June 2023, share the link with friends and acquaintances, this video has already been watched 508 times on youtube and it was liked by 9 viewers. Enjoy your viewing!

1,219