Viewing 15 posts - 2,401 through 2,415 (of 8,416 total)
David.Poole (11/11/2010)
On big systems you want your tables as efficient as possible and NULL values require a setting in the 192 byte record header.
What are you referring to here, David?
November 14, 2010 at 11:57 am
WayneS (11/12/2010)
I assume you mean with the OPTION (RECOMPILE) hint? Sure did.
Yes, but as Jeff pointed out, any recompilation will do - it doesn't have to be explicitly requested (for...
November 12, 2010 at 9:43 am
Henrico Bekker (11/12/2010)
...oh and I reached a 1000 point...small milestone 😀
Congratulations!
November 12, 2010 at 5:16 am
The Dixie Flatline (11/11/2010)
What is the purpose of having log entries for a table variable? or How are they used?
The first part of the answer is...
November 12, 2010 at 12:24 am
WayneS (11/11/2010)
November 11, 2010 at 9:58 pm
The Dixie Flatline (11/11/2010)
Let me ask what logging takes place with table variables, since they are not affected by rollbacks.
Try it for yourself:
-- Guaranteed to be in SIMPLE recovery
USE tempdb;
GO
--...
November 11, 2010 at 9:55 pm
Hi Tim,
I almost see what you're getting at, but it would make it a lot easier to help if you could provide a CREATE TABLE statement, and a few rows...
November 9, 2010 at 9:37 am
WayneS (11/8/2010)
November 8, 2010 at 11:25 am
ALZDBA (11/5/2010)
I received feedback from MS ....
Wouldn't it be nice if MSFT put a bit more effort into their replies on Connect?
Just confirming the bug is nice of course, but...
November 5, 2010 at 4:56 am
CirquedeSQLeil (11/4/2010)
Yeah - I publish under my real name too. I was thinking of changing to match my twitter and blog.
FWIW I find the SQLRunner vs SQLRunr vs SQLRnnr...
November 4, 2010 at 10:12 pm
CirquedeSQLeil (11/4/2010)
Is the water cooler out of water today?
Yes.
November 4, 2010 at 10:58 am
Chris Morris-439714 (11/1/2010)
Y.
That's a pretty efficient answer right there!
November 1, 2010 at 8:08 pm
Chris Morris-439714 (11/1/2010)
Ooh you cheat, that's not a fix that's a different method altogether 😉
Yes I do cheat. Proud of it! :laugh:
November 1, 2010 at 7:59 am
Chris Morris-439714 (11/1/2010)
Nah mate my walking-on-water skills are still underwhelming - don't even drink the stuff, fish f...never mind. Spill the beans! I'll try to understand, promise!
SQLCLR, naturally - using...
November 1, 2010 at 7:44 am
Chris Morris-439714 (11/1/2010)
Heh - until you wrap it up nice and warm...
That helps - as usual - but it's still a bit slower than the (unmodified) XML PATH solution I...
November 1, 2010 at 7:32 am
Viewing 15 posts - 2,401 through 2,415 (of 8,416 total)