Viewing 15 posts - 6,856 through 6,870 (of 8,416 total)
I just want to add:
MAX data types like VARCHAR(MAX) are not 'out of row' data types. By specifying 'MAX' you are letting the storage engine choose how best to...
October 16, 2009 at 2:12 am
Total worker time is the counter that makes most sense to me when tuning SQL Server.
Logical reads can be useful as a rough guide on occasion.
Elapsed time is also relevant.
However,...
October 16, 2009 at 1:52 am
RBarryYoung (10/6/2009)
October 10, 2009 at 7:07 pm
Matt Whitfield (10/6/2009)
Paul White (10/6/2009)
Guilty as charged, though in mitigation I'd just say that I was attempting humour.Probably should have left it alone, yes.
A quote from Orbital: 'It's better to...
October 6, 2009 at 6:50 pm
If Atul finds my attempt at humour offensive I'll gladly apologise and delete the post.
Paul
October 6, 2009 at 5:38 pm
RBarryYoung (10/6/2009)
RBarryYoung (10/6/2009)
Paul White (10/6/2009)
4. How many questions on the homework paper?:laugh:
*ding* *ding*, Looks like you cynicism tank is almost full Paul. 🙂
Ah yes,...
October 6, 2009 at 5:36 pm
Gianluca Sartori (10/6/2009)
You sigh, but Paul's reply made me laugh!:hehe:
...and Matt's did for me!
I can see it now:
EXEC sp_AbraKebabra @ChilliSauce OUTPUT;
And yes, there is a local take-away here called Abra-Kebab-ra...
October 6, 2009 at 3:54 am
Jeff Moden (10/5/2009)
Jan Van der Eecken (10/5/2009)
"What are some uses of Dihydrogen Monoxide?"
Heh... the very same as Hydrogen Hydroxide. "Oh bartender! Can you fix me a Perrier and...
October 6, 2009 at 3:44 am
4. How many questions on the homework paper?
:laugh:
October 6, 2009 at 3:36 am
I broadly agree with Barry and Marcin. It is very common in (predominantly) OLTP applications to set MAXDOP 1 server-wide. Parallelism can then be enabled per query using...
October 6, 2009 at 3:34 am
TheSQLGuru (10/5/2009)
October 6, 2009 at 3:17 am
Bob Hovious 24601 (9/22/2009)
Spend enough cache and you can buy a better query plan?(Sorry, Emperor Paulpatine. I just couldn't resist.)
:laugh: You get worse Bob! :laugh:
October 4, 2009 at 4:20 pm
RBarryYoung (10/3/2009)
Ah yes, I'll never forget my first time. That poignant, bittersweet moment when your code first gets promoted ahead of you ... 😀
That made me smile on...
October 4, 2009 at 4:18 pm
My first addiction was to the cartridge version (woot) of Galaxian on the VIC-20. Awesome game.
October 4, 2009 at 4:16 pm
Matt Whitfield (10/4/2009)
laughingskeptic (10/4/2009)
Clearly you did not understand the code. COUNT returns one row. My code returns the vector 0..N-1 based on the size of the target table.
I've...
October 4, 2009 at 4:14 pm
Viewing 15 posts - 6,856 through 6,870 (of 8,416 total)