Viewing 11 posts - 1 through 11 (of 11 total)
Great article, and on the spot.
The key here is to understand that you probably dont know the context in which the code was written.
"Just get it done by...
November 14, 2011 at 2:41 am
What about the interesting issues raised by the question?
To me, it is strange why the sqlserver team is avoiding adding an option to materialize intermediate tables from CTE's. Oracle has...
April 26, 2011 at 7:23 am
GilaMonster (7/5/2010)
http://msdn.microsoft.com/en-us/library/ms191244%28SQL.90%29.aspx
Ok, so a "normal" INSERT....SELECT * FROM X doesn't cut it for minimally logged?
July 5, 2010 at 9:50 am
I'am still a bit confused about the "minimaly logged" operations stuff.
I've tested different recovery modes, performed an "insert into x(id) select id from x" (something I thought was a...
July 5, 2010 at 9:21 am
Where did the follow-up article go? I cant seem to be able to find it.
August 18, 2009 at 7:17 am
If just ms would implement the lead() and lag() analytical functions, this stuff would be straight forward.(http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=254388)
Other analytical functions like first_value and last_value would also be much appreciated....
January 23, 2009 at 4:07 am
Vladan (6/6/2008)
Can you explain a little bit...
June 6, 2008 at 3:15 pm
Lynn Pettis (6/5/2008)
I'll do a little digging. Second question, though, could you use a uniquely named global temp table (##Temp01)?😎
Great!
So far, I've looked into SQLDMO, but I'm only able...
June 6, 2008 at 4:47 am
Lynn Pettis (6/5/2008)
Could you explain this in a little more detail?Due to scoping restrictions, I am not able to perform a "select * into #temp from sourcetable".
😎
As the sourcetable...
June 5, 2008 at 4:23 pm
I've three uses for temp-tables
1. Splitting up queries where complex predicates confuse the optimizer
2. Passing datasets between stored procedures
3. As a worktable in procs where the return set is the...
May 30, 2008 at 4:50 am
My stance on SQLCLR is that it's just version 1.0. Its not too useful in set manipulation, but adds very convenient ways to fix a few irritating shortcommings in sqlserver...
January 25, 2008 at 6:14 am
Viewing 11 posts - 1 through 11 (of 11 total)