Except it's worse advice for extreme emergencies. You're advocating taking actions that can have consequences without any...

jonysuise (10/18/2013)

---

If you run out of space and sql server becomes unresponsive, switch the database’s recovery model to simple . This empties out the transaction log, and then run...

Why are you retrieving hundreds of millions of rows? What are you going to do with them?

I certainly hope you don't run the log backups without truncating the log, if you really do, you'll be running out of disk space very shortly. Log backups are supposed...

Koen, you are awesome. 🙂

:hehe:

The same command you specified in your initial post works fine. Monitor on a regular basis for a couple of weeks, see how big the log needs to be, then...

Fetch your latest backup, restore it as a new database, generate the table definition, execute it on the original database, copy the data over.

Monitor the log usage for a couple of weeks (especially after maintenance). See from that how large the log needs to be to support the app. Shrink the log to...

3)

Show me a database with integrity enforced by the application, I'll show you bad data in it.

Foreign key checks, to see if any rows reference this one and hence this one can't be deleted.

Jason, Wayne, Argenis, Denny are the ones I know.

I wasn't around for the flash mob, but that didn't stop Argenis and I having a repeat performance a little later

https://plus.google.com/photos?pid=5935932615867871922&oid=114437370872037465059

If the URL doesn't work, I'll upload it separately.

CapnHector (10/16/2013)

---

EDIT: After looking at it some more it really looks like this IAM page is not tracking any allocated space since there are no single page allocations and...

A mirror is an exact copy of the principal database in very way.

CapnHector (10/16/2013)

---

What is perplexing me on the error message is that object ID 0 and index ID -1 make no sense as the objects do not exist (unless they are...