Viewing 15 posts - 7,231 through 7,245 (of 7,614 total)
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
I am completely unable to get the float value to cast or convert to a varchar and not truncate it
From BOL:
"By default, the precision of built-in operations on float data...
September 7, 2012 at 3:44 pm
Lynn Pettis (9/7/2012)
CREATE TABLE #tblTemplates
(
...
September 7, 2012 at 2:51 pm
Viewing 15 posts - 7,231 through 7,245 (of 7,614 total)