More to read by The Pythian Group[/url]:

http://www.pythian.com/blog/the-death-of-the-mcm-program/[/url]

We have MCMs and few DBAs already passed first tests :angry:

Shame!!

I am having the same issue and found this link: http://support.microsoft.com/kb/918038

I decided to post it here, it may help others :hehe:

... And I was wondering... 🙂

What are your thoughts about Adam Machanic's article:

http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/running-sums-redux.aspx ?

I tried to compare Adam's code to other options and came up with this...

Hi there,

As an experienced DBA, I can identify with every single word in this article.

Of course you can write your set-based application in such a way that cursor will perform...

My guess is that you have a problem with your transactions handling.

You didn't mention what is the programming tool you are using, this piece of information might help to analyze...

...And what's the excuse today...?  Monday, Monday...?

BTW, I read that cursors can also produce this behaviour. A cursor is opened once or twice a day.

Come on, guys...

I heard that this is the best WEB site for SQL SERVER questions...