Seeing Exactly Where SQL Server Stores Each Column
You add a couple of varchar(max) columns to a table because you are not sure how big the values will get. Most rows hold a few dozen characters. A handful hold tens of thousands. Everything…
How SQL Server Stores DATETIME2, DATE, and TIME
This post is part of the series. The contents page lists every part in order. In I took a DATETIME apart byte by byte: two 4-byte integers, a date counted from 1900 and a time…
How SQL Server Stores a DATETIME, Down to the Bytes
This post is part of the series. The contents page lists every part in order. Every DBA eventually asks the same odd little question. You insert ‘2024-03-14 09:26:53.999’, read it back, and it says 09:26:54.000…