How does SQL Server store that data type? ~ Randolph West

WHEN:
Wednesday, October 11, 2023, 1600 GMT

DESCRIPTION of TALK

Title: How does SQL Server store that data type?

If you've ever been curious about how each data type looks on your storage subsystem, this is the session for you. We'll step through each data type, and how the hex looks at the storage layer.

You will understand why certain data types are better choices than others. I'll show you a few surprises, and settle an old score with DATETIME.

Breaking out the hex editor might automatically qualify this as a 500-level session depending on your appetite for nerdy goodness, plus you should be able to use this information for data recovery (like I have).