Viewing 7 posts - 1 through 7 (of 7 total)
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...
April 1, 2011 at 12:03 am
+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...
June 14, 2010 at 7:59 pm
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...
May 9, 2010 at 10:06 pm
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...
March 8, 2010 at 11:22 pm
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...
March 3, 2010 at 12:07 am
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.
January 12, 2009 at 4:53 am
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...
January 11, 2009 at 11:20 pm