Viewing 15 posts - 661 through 675 (of 8,416 total)
Steve Jones - SSC Editor (5/17/2012)
Smart-*** Kiwi.
Paul Randal started it. :laugh:
May 17, 2012 at 1:46 pm
Jeff Moden (5/17/2012)
Heh... I have the proof. I just haven't posted it. Time for someone else to prove it besides me. 🙂
Well that doesn't really help anyone else...
May 17, 2012 at 1:44 pm
Gullimeel (5/17/2012)
The overhead of the querying two extra tables is just 3 logical IO's.
You're still just optimizing for logical I/O, not the whole cost of executing the extra statements. ...
May 17, 2012 at 1:34 pm
OPTION (RECOMPILE) would be my choice here. The execution plans generated are not cached, so pushing other plans out of cache is not a concern. On my laptop,...
May 17, 2012 at 11:01 am
Steve Jones - SSC Editor (5/17/2012)
Zip, gender, birthdate gets some crazy % identified, or closely identified. Add in one other thing and I think it gets to like 98% likelihood.
Address?...
May 17, 2012 at 10:20 am
Jeff Moden (5/17/2012)
Shifting gears, just changing it to a While Loop using the exact same logic will make it more efficient.
It's not like you to make such a bold statement...
May 17, 2012 at 8:40 am
Jeff Moden (5/17/2012)
May 17, 2012 at 6:53 am
Jeff Moden (5/17/2012)
SQL Kiwi (5/16/2012)
Craig Freedman has a couple of great posts covering how recursive CTEs work:http://blogs.msdn.com/b/craigfr/archive/2007/10/25/recursive-ctes.aspx
http://blogs.msdn.com/b/craigfr/archive/2007/11/07/recursive-ctes-continued.aspx
I do wish folks would do a comparison against the equivalent While Loops to...
May 17, 2012 at 6:07 am
dwain.c (5/16/2012)
BTW. Someone recently linked me to (I believe it was) your article on the recursive CTE version of a really fast DISTINCT. Great job there!
Thank you (though...
May 16, 2012 at 11:41 pm
Craig Freedman has a couple of great posts covering how recursive CTEs work:
http://blogs.msdn.com/b/craigfr/archive/2007/10/25/recursive-ctes.aspx
http://blogs.msdn.com/b/craigfr/archive/2007/11/07/recursive-ctes-continued.aspx
May 16, 2012 at 11:11 pm
And on the same day:
http://sqlblog.com/blogs/jamie_thomson/archive/2012/05/10/datefromparts.aspx
May 10, 2012 at 9:44 am
WayneS (5/10/2012)
I tried (and sent this QotD to several folks to get their opinions) to make this a good QotD without this controversy.
Oops! I did see your mail, Wayne,...
May 10, 2012 at 9:25 am
marlon.seton (5/8/2012)
May 8, 2012 at 9:33 am
Nils Gustav Stråbø (5/7/2012)
SQL Kiwi (5/5/2012)In fact the second format seems to be 0.003 second time intervals, rounded to 0, 3, or 7 in the third decimal place when used:
Which...
May 7, 2012 at 7:29 pm
Hugo Kornelis (5/7/2012)
Thanks, Paul! You saved me a lot of time by addressing all the points I wanted to address after reading the explanation of this question.
Makes a change! ...
May 7, 2012 at 4:55 am
Viewing 15 posts - 661 through 675 (of 8,416 total)