Try putting a check just before the exists, run the proc from management studio and see what you get back.

SELECT @foundFolderId

SELECT * FROM pageList WHERE folderID = @foundFolderId AND...

Multiple separate RAID arrays is best. The log and data files should be physically isolated from one another.

Don't bother. All the log reader tools need the database to be online. Besides, all that you'll...

Exists doesn't return false results.

Are you sure that the variables are such that rows may not exist? Maybe put a statement just above that to insert the rows that...

It's not a new concept. It existed on SQL 2000 as well. Probably 7 too, though I don't have any docs.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx

Significant quotes:

Tail of transaction log

The transactions that have been committed...

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...