Good one!!

Jeff Moden: Yes, we can

SSC-Enthusiastic: Becoz thats where we observe the max utilization and we can do max optimization!!

Agree with Geoff 🙂

sfrancis: Does it load the system performance? How often does this run?

Satalaj, I think your problem most probably is indexing. Make sure you have the proper indexes on your table and make sure your queries always use that index. Having no,...

Hi Satalaj,

Using the UPDLOCK in conjunction with the READPAST gives the best performance for processing queues. ReadPast however, needs an index on the order by column to work properly. Do...

Reply to rance.malcom: Why dont you use MS profiler to run a trace and check instantly?

Does the second call of the SP wait for the first call to end? It should skip the rows locked by the first call and delete the next ones.

Have the...

Does the second call of the SP wait for the first call to end? It should skip the rows locked by the first call and delete the next ones.

Have the...

Satalaj, you have to make sure that while running procedures in infinite loop, you make sure that you identify which procedures running parallely are getting the CPU usage up (by...