http://dbace.us/repriser/sqlpass/DeleteLargeWithBatch.htm

Check if you have appropriate indexes.

DBA, it is called archiving or set to read-only.

Most server comes with 8 SAS drive connectors as default. You can have 4 RAID1 or 2 RAID10 without extra cost. You run out of disk groups soon because you...

I think Kevin is right on target. I have an instance like that. The fix is in CU4 after SP3.

Grant Fritchey's ebook from redgate ---- you must read.

Using software like doubletake, you can replicate (copy) disk array at data-block level to another environment and keep them in...

I had all databases in "recovery pending" not because of disks nor memory. It was from SQL Server upgrade running into an error. The error was caused by 3rd party...

How does this fall back to developers?

Msg 6512, Level 16, State 27, Line 1

Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x80004005. You need to restart SQL...

I would change f.size to f.maxsize. case when 0, -1 use f.size.

Also the 2005 table is sys.database_files. sys.sysfiles is only provided for backward compatibility.

The scheme and the idea are very good. However, I will suggest improvement as:

1) make threshold parameter of the SP so you can change it on the agent job without...

The reason large select is blocking is due to lock-escalation. In SQLServer2008, you can disable lock-escalation by command set lock-escalation disable. How big is your select? How many tables? Have...

For example, a specific code case, procedure sys.sp_MSacquireSlotLock,

this is a procedure used in merge replication to limit the number of concurrent merge process. However, when the exclusive lock cannot be...

You can find the documentation on SQLServer2008R2 BOL.

This is one of the stupid design.

Imagine old days, you go to library asking for a book for a page you need. It...

Just a side note, SELECT INTO only works for new table, it works for this scenario asked.

For on-going archive, you can write a controlled transaction if you are not...