A...

Switch it to compatibility mode 90?

SELECT Department, ROW_NUMBER() OVER (Partition By Department Order By department) AS DeptSeq

FROM

Departments

Not by much, I really doubt it's a measurable amount. There aren't that many intermediate pages in an index.

I would guess that reading the intermediates also lets SQL...

Jack Corbett (2/25/2010)

---

I actually found a solution on another forum site that suggested making changes to the system tables. No way was I going to suggest that since I'd...

I wait with anticipation... 😀

Gee, impatient are we....? This is a forum, not a chatroom. Asking a rather complex question and then bumping it after less than 4 hours is really not called for....

I doubt there will be. This looks...

I can tell you how to fix this, but you are not going to like it.

I am going to guess here that this is a database upgraded from SQL 2000....

None. Those errors are not repairable.

Casper101 (2/25/2010)

---

During my index rebuild, some DB's log files grow really big. I have been advised to switch the recovery model to BULK_LOGGED before the rebuild, and then back...

Why oddly? That's what the model database is, a model for...

Neil Thomas (2/25/2010)

---

Hundreds of rows of data are written to one specific table in the database, but I can't work out why the transaction log isn't filling. Can anyone shed...

Paul Randal (2/25/2010)

---

For the page latch message - when the final PFS page at the end of the file is damaged (which could be the case here), I couldn't tell...

Because sometimes autoupdate doesn't update often enough

Could you tell me, Update statistics jobs,...