Not enough information to tell you precisely what the solution might be. Is the disk you moved the storage to in the exact same configuration and speed as the disk...

Again, not knowing what's happening inside that procedure, I can't definitively say that yes, you can eliminate the cursor. But I'm still very strongly suggesting it.

rahuldhawan2007 (6/26/2012)

i'm new to sql sever. i have few queries

1. what is composite key in a database

2. what is a candidate key

3. what is difference between varchar and nvarchar...

While there have been no service packs, they just released Cumulative Update #2. I strongly recommend installing it.

Assuming we're talking about a data file and not a log file, something had to have filled that space. Do you have load processes or queries that use tables for...

The majority of people do, but it's not a guaranteed approach.

You're right, every organization attacks that differently. The best documentation I've seen for laying out roles & responsibilities is an older book called "Database Administration" by Craig Mullins. It's still...

Without seeing & testing the code, it's hard to make a definitive answer. But based on what you've said, yes, I suspect strongly that the cursor is going to affect...

I only do a little bit of consulting. I know that others do more.

Brandie Tarvin (6/25/2012)

Matt Miller (#4) (6/25/2012)

SQLRNNR (6/25/2012)

Or...

Oh yes! I think varchar(1)...

You can query directly against the msdb tables for SQL Agent, if Agent is running the backups. But if the schedule is external... you're probably out of luck.

The quickest method, but not necessarily the most accurate, is to use the dynamic management objects (DMOs). If you select from sys.dm_exec_query_stats, you can see aggregate calls for all queries...

All that's telling you is that the object id's listed, one was waiting on the other. Look up the name of the object using object_name(objectid).

Instead of focusing directly on the...

I'm not sure what to do about the Red Gate backup logs, but that software works directly with the SQL Agent on the servers, so you should be able to...