How should I store currency values in SQL Server?
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?
Home »
bigint
How SQL Server stores data types: money
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
How SQL Server stores data types: integers and decimals
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
Negative identity values don’t suck
A quick(er) post this week, in response to Greg Low’s blog post from a few weeks ago titled “Don’t start identity columns or sequences with… Read More »Negative identity values don’t suck
Data Efficiency in SQL Server: DECIMAL
This is part two of a short series of posts about how I assign efficient data types when designing a new table or database. Use… Read More »Data Efficiency in SQL Server: DECIMAL