Viewing 15 posts - 346 through 360 (of 378 total)
A CTE is a temporary result set, which is valid for the scope of a single Select Update Insert or Delete statement.
BEWARE
This claim is false, and proof is included. A...
January 23, 2009 at 8:18 am
Jeff Moden (1/22/2009)
peter (1/22/2009)
Jeff, any luck in finding the saved "function argument" you mentioned?
No, sorry... I can't even remember who the "argument" was with...
Touch a minimal set of...
January 22, 2009 at 4:19 pm
Jeff, any luck in finding the saved "function argument" you mentioned? I would love to have a look at that earlyer discussion. BTW. This seems to be part of the...
January 22, 2009 at 2:47 am
I like the article, especialy the part about saying NO. While I don't like the rigid attitudes it is a valuable instrument that usually pays off. It helps to think...
January 13, 2009 at 4:44 am
phystech (1/10/2009)
peter (1/10/2009)
January 10, 2009 at 2:33 pm
phystech (1/10/2009)
Adam Haines (1/8/2009)
...First there should be some sort of filter in the first CTE. This way you can reduce the amount of data searched through...
You are using...
January 10, 2009 at 5:22 am
Adam Haines (1/8/2009)
I love how you only return the totals in the first row of the output. this will definitely reduce the amount of data being returned to the...
January 8, 2009 at 9:11 am
TheSQLGuru (1/8/2009)
January 8, 2009 at 8:42 am
First I am back a day later then I expected and definatly had hoped for, sorry for that. And please someone FIX this forum (smileys in code, persistent extended page...
January 8, 2009 at 4:41 am
First impression....a lot of code (and a lot of work).
I do not have the time to read the lengthy article in full but as the OP rightly articulated, the problem...
January 6, 2009 at 7:03 am
Jeff is quiet about my posts - too quiet....is a storm coming?
LOL
December 23, 2008 at 2:23 am
To Jeff mostly,
To bolster my claim about function overhead being the great killer in this debate.....I read your article about the function that you wrote for determining the number of...
December 22, 2008 at 7:04 am
Jeff,
You be happy to know that your understanding of set based code and mine are 100% the same, going by what you posted in this threat. But still I cannot...
December 22, 2008 at 5:59 am
We might also need to make sure all tests are performed on a database with the same recovery modal (tempdb uses 'simple') and a comparable load if we are going...
November 28, 2008 at 9:22 am
Lynn Pettis (11/28/2008)
In the code below I create a 1,000,000 row Tally table starting at 1. The table has one column, n. This is also...
November 28, 2008 at 8:57 am
Viewing 15 posts - 346 through 360 (of 378 total)