Christian,

I found this very informative web-page that states it is always page 9 in file 1. It goes on to give excellent details on what is on the page.

Joe

I liked the question, but think the answer could have been just yes. I didn't know that the table scans stats were included "free" in the rebuild. A question I...

My apologies, you are correct. It was listed under Sql Server 2008 category.

Steve Jones - Editor (7/10/2008)

---

The question listed the category as SQL Server 2008, and it does not apply...

brewmanz,

Even though I GUESSED correctly, I agree with you. The only reason I didn't go with host level is that the write-ups stated that you couldn't limit resources across instances....

Good post. This SQL will come in very handy!

As a quick verification of log shipping I check the properties of the source database and the destination database. The date and time of the last database backup and the...

I have always used rowcount (hang over from Sybase days)

But using top in the delete would save doing the rowcount. I've forgotten the set rowcount a enough times that using...

That's why I feel answer b is not correct. Answer b says the value is converted to an int. The error message says the conversion failed. So, it appears to...