Viewing 15 posts - 7,231 through 7,245 (of 7,616 total)
Sean Lange (9/13/2012)
ChrisM@Work (9/13/2012)
ScottPletcher (9/12/2012)
It would have to be THE ONLY WAY POSSIBLE...
September 13, 2012 at 10:38 am
I think maybe you can save a little overhead by checking for the known difference expected in the result, naturally including the next-higher value as well to allow for "borrowing"....
September 12, 2012 at 5:09 pm
1. What does the GroupID column in profiler mean ?
GroupID as classified by the Resource Governor for the current session.
September 12, 2012 at 4:42 pm
There is NO case where I would ever want to use a GUID as a clustered key column.
It would have to be THE ONLY WAY POSSIBLE for me to consider...
September 12, 2012 at 4:31 pm
GilaMonster (9/12/2012)
Well, both of those statements are incorrect, so probably better to just ignore them...
Quite true.
September 12, 2012 at 4:27 pm
Lynn Pettis (9/11/2012)
Lynn's method:
Elapsed Time (ms) 8276
ScottPletcher's first method:
Warning: Null value is eliminated by an aggregate or other SET operation.
Elapsed Time...
September 11, 2012 at 1:06 pm
Lynn Pettis (9/10/2012)
ScottPletcher (9/10/2012)
Lynn Pettis (9/10/2012)
ScottPletcher (9/10/2012)
Greg Snidow (9/10/2012)
ScottPletcher (9/10/2012)
The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.
Yep, as...
September 10, 2012 at 5:09 pm
Lynn Pettis (9/10/2012)
ScottPletcher (9/10/2012)
Greg Snidow (9/10/2012)
ScottPletcher (9/10/2012)
The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.
Yep, as I said, I...
September 10, 2012 at 4:28 pm
Greg Snidow (9/10/2012)
ScottPletcher (9/10/2012)
The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.
Yep, as I said, I put that out...
September 10, 2012 at 4:18 pm
Lynn Pettis (9/7/2012)
September 10, 2012 at 1:25 pm
The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.
September 10, 2012 at 9:38 am
If you want precise control over shortening the results returned from a float column, there is always the ROUND() function.
If you want precise values, just use decimal to begin with....
September 7, 2012 at 4:17 pm
Lynn Pettis (9/7/2012)
September 7, 2012 at 4:11 pm
1. Columns are fields!
Technically they are not.
But in practice, many people refer to SQL columns as "fields", so you just have to accept that and move on.
September 7, 2012 at 3:55 pm
Why does the float value change to a smaller number when the precision increases?
Maybe just the general nature of floating point values, that they are approximations only.
September 7, 2012 at 3:50 pm
Viewing 15 posts - 7,231 through 7,245 (of 7,616 total)