Viewing 15 posts - 7,846 through 7,860 (of 8,416 total)
Adam Machanic (6/4/2009)
June 4, 2009 at 3:08 pm
Jeff Moden (6/4/2009)
June 4, 2009 at 3:01 pm
Jeff Moden (6/4/2009)
There was some really cool things I was going to show about the Clustered Index but guess folks will just have to wait for the "book" now. 😛
Don't...
June 4, 2009 at 2:56 pm
WayneS (6/4/2009)
Paul White (6/3/2009)
One thing to mention is that the article is the first of a seriesWell, actually it's the second in a series.
The magazine I just had delivered...
June 4, 2009 at 2:53 pm
Jeff Moden (6/4/2009)
Here's the reason why I use Index(0) instead of Index(1). From BOL:
Cheers Jeff - it was your motivation in including the hint I was after really (though...
June 4, 2009 at 7:40 am
GilaMonster (6/4/2009)
June 4, 2009 at 5:41 am
Hey Jeff,
Really neat demonstration. Love it. Lots of cool optimizations too.
The ultimate demo is where the original table already happens to have a suitable clustered index (it does...
June 4, 2009 at 4:24 am
Lynn Pettis (6/3/2009)
Could you explain this in a little more detail? I am curious what you mean by it.
I took it to mean a moving-sum (like a moving average)...
June 3, 2009 at 8:06 pm
Adam Machanic (6/3/2009)
This answer surprises me; I thought that given your interest in the technique you would already have an answer here. If not for speed, what's your purpose in...
June 3, 2009 at 6:16 pm
Payal Bansal (6/2/2009)
http://www.sqlservercentral.com/articles/Administration/2582/
To save people clicking, that is the approach outlined by Grant in post 3 on this thread.
It's a reasonably old article and could stand updating for 2K5 and...
June 3, 2009 at 6:05 pm
I subscribe and have just scanned the article. It is a quality piece of work, and looks to be very thorough (as one would expect).
One thing to mention is...
June 3, 2009 at 5:58 pm
GilaMonster (5/29/2009)
Split them out into subprocedures. The reason is parameter sniffing.
+1. Splitting into sub-procedures is the best solution.
Your other alternatives are:
1. RECOMPILE on the EXEC call, on the...
May 30, 2009 at 2:45 am
GilaMonster (5/28/2009)
Anyone (preferably someone who's telepathic or precog) want to tackle these?
Outstanding. Just totally awesome in its awesomeness.
How could I resist? 😉
May 28, 2009 at 4:09 pm
Chris Morris (5/28/2009)
There's gonna be a queue behind you on this one, Paul. Wait a minute..."W"...you're gonna be somewhere near the end.
Chris, the best index is a descending index IMO...
May 28, 2009 at 4:08 pm
Lynn Pettis (5/28/2009)
Help. I can't remember the procedure I need to run to sync orphaned users in a database. Please help me.....
sp_change_users_login
Aaargh! that proc!!! - I can never...
May 28, 2009 at 4:06 pm
Viewing 15 posts - 7,846 through 7,860 (of 8,416 total)