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 manufactured by Intel and other vendors process binary values in reverse order (known as little-endian), with the least significant byte in a binary value first, and the most significant (i.e.
-> Continue reading How SQL Server stores data types: DATETIME, DATE, TIME, and DATETIME2
The post How SQL Server stores data types: DATETIME, DATE, TIME, and DATETIME2 appeared first on Born SQL.