SQL Tact

Here's a new thing to be scared about in the night, as if you weren't already terrified of floats after my previous two posts about...

This is a followup to a previous post where I likened SQL Server float datatype to Muhammad Ali. Specifically, I wanted to address the phr...

Wrote this email recently to a crew of developers who were shooting themselves in the foot with a database rich in varchar(max) data types. ...

Starting with SQL 2008, we database developers started becoming more familiar with datetime2.  Sometimes folks need convincing though, so he...

I distinctly remember having to tell my CIO and a VP of Finances in 2005 that the reason their reports were off by one cent from the ledger ...

Was inspired to write up a few notes on the SQL Server data type.  This is pretty basic stuff, but everyone should know it. If you declare ...

So, to save space (and it is a bit archaic, but why not) I sometimes use tinyint and smallint for the PK IDENTITY columns in small lookup ta...