Viewing 15 posts - 181 through 195 (of 8,416 total)
Dominic_godfrey (9/24/2012)
I'm not exactly sure what CELCO was on about but I will read the "netiquette" before posting again and look up what DDL is.
It's hard to know for sure,...
September 24, 2012 at 10:50 pm
dwain.c (9/23/2012)
I'm not sure why no one mentioned this (maybe I missed it?) but my favorite way to keep the pieces of a complex query understandable is Common Table Expressions.
CTEs...
September 24, 2012 at 10:42 am
Mark-101232 (9/24/2012)
NULL can also be handled by adding 'RETURNS NULL ON NULL INPUT' to the wrapper.
Yes that is true.
I did wonder about asking what should be returned for NULL input.
Some...
September 24, 2012 at 6:50 am
Mark-101232 (9/24/2012)
Unrolling the loop yields a small performance gain. Still doesn't handle NULLs or -2147483648 though.
Unrolling the loop is an interesting idea, I will have a play with that...
September 24, 2012 at 6:22 am
Jeff Moden (9/23/2012)
Thanks for the explanation, Paul. It's been a long time (6502 days) since I've even gone near machine language.
Me too! My first ever computer was a...
September 23, 2012 at 3:01 pm
Bobby Glover (9/21/2012)
September 23, 2012 at 2:02 pm
L' Eomot Inversé (9/23/2012)
September 23, 2012 at 1:06 pm
Right. Working back through the comments completed 🙂
Thank you Jeff for so many mentions in your fine article!
September 23, 2012 at 12:47 pm
L' Eomot Inversé (9/23/2012)
rragnmo seemed to me to be talking about two distinct thigs - a...
September 23, 2012 at 12:45 pm
Jeff Moden (9/23/2012)
SQL Kiwi (9/23/2012)
The C# code will indeed be compiled down to just one machine-code instruction (which may take less than one CPU cycle to execute)...
Are you sure, Paul?...
September 23, 2012 at 12:38 pm
milldyce (8/1/2012)
A bit of a tangent, but I remember a number of queries for which response times exploded when trying to view the Execution Plan.
Requesting an actual execution plan causes...
September 23, 2012 at 12:34 pm
RichB (8/1/2012)
Have you tried looking at these with a server side trace? I'd be very curious to know whether that can have a similar problem.
Yes a server-side trace has...
September 23, 2012 at 12:31 pm
G Bryant McClellan (8/1/2012)
September 23, 2012 at 12:29 pm
Removed. (I quoted Jeff partially quoting Barry without reading all the way back to see that Barry had already referenced the document I wanted to mention).
September 23, 2012 at 12:17 pm
rragno (8/5/2012)
September 23, 2012 at 12:10 pm
Viewing 15 posts - 181 through 195 (of 8,416 total)