Viewing 15 posts - 1,591 through 1,605 (of 8,416 total)
Jack Corbett (11/4/2011)
November 4, 2011 at 8:24 am
Hugo Kornelis (11/2/2011)
michael.kaufmann (11/2/2011)
Hm, do you have an explanation why the following code will return the exact same result? :crazy:
My guess would be that your server has a default collation...
November 2, 2011 at 5:19 pm
Britt Cluff (11/1/2011)
Wow, did I have to think on this one. Thanks for the interesting question.
Me too - and I wrote the thing (a month or so ago).
November 1, 2011 at 6:06 am
L' Eomot Inversé (11/1/2011)
Excellent question.I wonder if there's another on sql_variant in the pipleline?
Not at this stage, at least not by me. I was going to do one based...
November 1, 2011 at 6:05 am
call.copse (11/1/2011)
November 1, 2011 at 5:56 am
Hugo Kornelis (11/1/2011)
Your production code will likely be more careful with these issues.
Can I interpret this as "Your production code will likely completely avoid the use of SQLVariant"?
(Okay,...
November 1, 2011 at 2:55 am
Hugo Kornelis (10/27/2011)
I had the correct answer,but only thanks to the fact that I attended SQL Saturday in Portland a few weeks back (just before the PASS Summit)....
October 27, 2011 at 2:11 pm
Michael Lysons (10/27/2011)
And, more importantly, congrats on winning the Webb Ellis, SQL Kiwi!
Still celebrating here!
October 27, 2011 at 2:08 pm
Gianluca Sartori (10/27/2011)
Great question, Paul, and great explanation.Looks like you tricked most of us (myself included).
Thanks, but I want to say that I really really really didn't set out to...
October 27, 2011 at 1:30 am
tommyh (10/27/2011)
Yes the stream aggregate gets called first... but it hasnt finished. So is the important part which gets...
October 27, 2011 at 12:47 am
Fal (10/23/2011)
Ah bugger. New Zealand won the Rugby Union World Cup. A certain someone is gonna be absolutely intolerable now. 😛
I will be, once (or if) I...
October 24, 2011 at 12:23 pm
jared-709193 (10/18/2011)
October 18, 2011 at 11:39 am
Brandie Tarvin (10/17/2011)
Have you turned into a zombie and not warned the rest of The Thread? I'm looking at your avatar and wondering if I should pull out my Zombiepocalypse...
October 17, 2011 at 1:53 pm
SQL Kiwi (10/17/2011)
One thing you might like to look at, to eliminate that eager spool: http://blogs.msdn.com/b/sqlqueryprocessing/archive/2008/09/22/distinct-aggregation-considered-harmful.aspx
Just remembered: there's an optimizer improvement in Denali SQL Server 2012 RC0 (not in CTP3)...
October 17, 2011 at 11:19 am
Ninja's_RGR'us (10/17/2011)
October 17, 2011 at 11:09 am
Viewing 15 posts - 1,591 through 1,605 (of 8,416 total)