SQL Server: Data Types
Getting bit by datetime rounding or why 23:59:59.999 > '23:59:59.999'
Why won't SQL Server store the datetime values you insert? Learn & understand why SQL Server will round any values of .998 or .999 to either .997 or .000 precision.
Saving space by storing decimal values in integer data types
Learn how to effectively store decimal values in SQL Server while taking up as little space as possible.
Bridging the gap between smallint and int
Learn the difference between smallint and int, as well as how to mimic the MySQL mediumint data type in SQL Server.
Wasted bytes add up, consider your data types carefully
You should consider your data types carefully when designing SQL Server tables. If not done properly you may waste lots of bytes per page.
Reading bits in OrcaMDF
Learn how bits are stored internally in SQL Server. In this post I'll also show how OrcaMDF parses bits from records.
Parsing dates in OrcaMDF
Learn how SQL Server data types like date, datetime and smalldatetime are stored internally. In this post I'll also show how OrcaMDF parses these types.
Tricky SQL Server decimal math
When performing math using SQL Server decimals, the precision may change and cause implicit conversions. Learn how to predict and avoid this situation.
|