Loved every minute of it. I just got back to SA...

Looks OK. I can't see a logic problem.

The count is not necessary and it's expensive, doubly so since you're doing a count of the column, not count(*)

Try changing the count...

Can you please fix the wrapping?

What's the proc supposed to do?

You can query the sys.dm_exec_requests for requests with a blocked_by that's not 0 and a wait_time exceeding your threshold.

Can someone give me a hand with this one? The earliest I'm going to have a change to sit down and work out some code is tomorrow afternoon when I...

It's doable. However, unless you can actually give us an example of the data (not a description, not the file extention) then it's not going to be possible to offer...

llokshin (11/23/2008)

---

HI, Gail, maybe I didn't make myself clear. I wanted to delete from some tables about 16 GB of data. I do it in small transactions, not all at...

I didn't ask for the entire proc. I said, if you want us to do all of the work for you, give us table definitions (as create table statements), sample...

The login name is not a valid identifier. Put square brackets around it.

Index rebuilds are logged operations and hence will cause tran log growth. There's nothing wrong.

You can switch to bulk-logged for the duration of the rebuild to reduce the impact on...

Try to run a backup from the query window - backup log...

If it doesn't work, what is the error?

Please post unrelated questions in a new thread.

In simple recovery the logs auto-truncate on a regular basis and hence cannot be backed up. There's no point, it wouldn't be possible to use such backups to restore because...

I've backed up and...

Bear in mind that a san doesn't automatically make things fast. To quote a friend, 'There's no magic san dust'

Even with a san (or especially with a san) you need...