Thanks guys I greatly appreciate your feedback.

You are welcome. If you need any advise at anytime, I would be happy to chat with you over email or what ever you might need. While I am not...

What would cause this type of behavior could be various reasons, the most likely cause to me would be a lack of statistics, or an undocumented change, or an update...

The behind the scenes optimizations that are out with SQL Server 2008 as well as the enhansements to SSIS, SSAS, SSRS development and T-SQL enhancements make it a no brainer...

Hey NO Bud Light for me! I am sure that Jeff has better taste than that as well. 😀

That is right, so now we can have Beer by Agonizing Beer until the pool table sinks away into the great abyss... either that or we do.

Never know, we may meet up somewhere sometime, and swap the best stories over a frosty mug. 🙂

Jeff,

Thank you for your addition to the forum, which I did state was resolved, and you were so gracious to point out that you did...

Dear Mr. Ballantyne,

Thank you for your contribution. Yes, I did not write this crap. Yes it is embedded EVERYWHERE, (NOTE) Previous DB Gods are not...

Seth,

Thanks so much for the reply back to my message. Having done this about 15 years now, I really was only looking for a...

Hey Everyone,

Thanks for all of the assistance and advice with this particular query. I was able to clean it up myself without the use...

Well both would be nice, but I would settle for getting rid of the while loop first. From there I could probably add it to a function that could be...

Glad to see that there are others that feel the same way that I do about _columns. SQL Server Books Online specifically mentions cursor_rows on each of the procedures with...

I have to say that I did not like this question either. If you only run the create and insert once you will consistently get the same results in each...