Viewing 15 posts - 7,216 through 7,230 (of 7,602 total)
Eugene Elutin (9/12/2012)
Greg Snidow (9/12/2012)
Jeff Moden (9/12/2012)
Greg Snidow (9/11/2012)
The 'id' column in every table was a bit annoying to work with.
It's even more annoying when you need it and it's...
September 13, 2012 at 1:39 pm
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
Viewing 15 posts - 7,216 through 7,230 (of 7,602 total)