A quick primer on binary and hexadecimal
A few years ago, I wrote that a CPU is “a hot mess of on-off switches.” There’s more to it than that when you get… Read More »A quick primer on binary and hexadecimal
Home »
binary
How SQL Server stores data types: dates and times
This post dives into how SQL Server stores date and time data types in memory and on disk. But first, a note about endianness: CPUs… Read More »How SQL Server stores data types: dates and times
Why is a value in DATETIME2 8 bytes, but in BINARY it is 9 bytes?
In the #sqlhelp Slack channel on the SQL Server Community Slack workspace last month, Jemma Hooper asked: When trying to CAST or CONVERT a datetime2… Read More »Why is a value in DATETIME2 8 bytes, but in BINARY it is 9 bytes?