lol. I read half the editorial then went to the 'join the debate...' link to see the uproar about using bigtable and nosql... before reading the rest...

+1 for the graphic T-SQL. (Maybe in the question forum a text version of the T-SQL can automatically be posted?)

-1 for the inconsistencies on when syntax and typos...

Good article.

In problem resolution I often find techniques that work on small databases do not scale that well to VLDBs.

Another solution could have been to simply update...

I figured the answer was going to be something related to CONVERT having the style parameter (and hence more capabilities), but then saw in BOL (2005) that "CAST and CONVERT...

Seems to be a lot missing assumptions. Each given answer can be correct given different starting conditions.

Running the code as-is got me an error first (tblUsers does...

It is a good question though. You'd assume the data type that uses more bytes for storage would have a greater 'precision' both ways of the decimal point.

Strange thing,...

In regards to the explanation of the answer, 'precision' normally means the total number of significant digits (at least in Math-world). Not just the fractional part, but the whole...