Next week on Wednesday 28 July 2021, I will be presenting a brand-new session titled “How SQL Server stores that data type” for the free… Read More »Join me at the EightKB virtual conference on 28 July 2021
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
This post looks at a curious data type that isn’t really a data type. Instead, sql_variant tries to be all things to all people. As… Read More »How SQL Server stores data types: sql_variant
Two years ago I wrote a post that got a lot of traction in the comments at the time. Last month there was renewed interest… Read More »The final word on storage for DATETIME2
On Twitter, Michael Dyrynda writes: ⚠️ Never ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever… Read More »How should I store currency values in SQL Server?
In this post we look at how SQL Server stores currency values using the MONEY and SMALLMONEY data types. If you’d like to read the… Read More »How SQL Server stores data types: money
This week we’re going to look at how numbers are stored. This post will cover integers (TINYINT, SMALLINT, INT, BIGINT), and decimals (DECIMAL, which is… Read More »How SQL Server stores data types: integers and decimals
A short post this week. On a mailing list recently, someone noticed that a .NET application writing to SQL Server did not have the expected… Read More »The easy way to handle UTF-8 in a .NET application when dealing with SQL Server 2019
It occurred to me that we haven’t covered the TIMESTAMP data type in this series about dates and times. TIMESTAMP is the Windows Millennium Edition… Read More »Dates and Times in SQL Server: What about TIMESTAMP?