You from Michigan, Kevin?

Heh... understood on the scheduling thing... not a predictable "tide".

Heh! Similar effect! Gets their attention and it's fun to watch! :hehe:

Dang! You got Grandholm for a Governor, too? 😛 They should leave out gasoline...

Haven't tried it, Matt, but is that true even when you're logged in as a System Admin?

Heh... (laughing out loud, now)... do you think it matters when you get hit in the kisser by a 90 mile an hour porkchop? 😀 😛 😉 :hehe:

Heh... only if I forget to take the brick out of my coffee pot from the water...

Heh... understood and thanks...

Becareful, though, Sam... one of the things that an Execution Plan will do, is "lie"... frequently, it can't "see" past the first row of the correlated sub-query...

Heh... spot on, Matt... Just like you did, I load what I call a "discovery load". The only difference is that I don't even take the time to change...

Jim... First, I absolutely agree with what you said... But, I also...

Heh! Man, I had to laugh out loud! I've done that many times myself... it's normally...

Heh... freeware...

My recommendation is that you read the license...

Samuel Vella (1/16/2008)

---

Jeff,

(Did you miss my earlier posts?)

Case would be a lot easier for very simple examples but sometimes @nbr is derived and for clarity/optimization it would be better to...

Hey Prashant...

You remember I said "don't let it dampen your writing spirit"? Here's why... like I said, you have some good information in your article and people have already...

...and everything happens in memory instead of a combination of memory and disk.

...while a temporary table exists until the server is brought down and also it uses lot of disk...