Actually the real problem with your query is the nolock hint.

use it only if you don't care about the accuracy of the results and the connection no getting whacked by...

Nah, he said in the teched presentation that he monitors this...

Paul Randal (8/9/2011)

---

There are hundreds of cases I didn't talk about in that presentation - but glad you liked it!

Sounds like memory corruption of a log block changing the slot...

And in the news, Google stills works :pinch:!

I should start Let Me google that for me (tm). 😀

Took the server offline and copying the files. It's 50 GB so...

GilaMonster (8/9/2011)

---

p.s. you've either got some IO error, a memory error or you've hit a severe SQL bug. See if you can repo on completely different hardware, see if you...

Darn. I wish this would have had more options to test.

Anyway I can backup the DB so we can retry a few things? I'm getting errors both in...

Another reason to use => 😉

GilaMonster (8/9/2011)

---

Which means it's in pseudo-simple recovery (log getting...

Got a nice corruption challenge for anyone who's interested...

http://www.sqlservercentral.com/Forums/Topic1157321-266-1.aspx

Edit.

Link to Paul's amazing presentation : http://channel9.msdn.com/Events/TechEd/NorthAmerica/2008/DAT375

I have good backups and I can erase that db anytime I want without any problems. I'm doing this more for the experience...

coder_t2 (8/9/2011)

---

Jeffrey Williams-493691 (8/9/2011)

---

Don't drop the nonclustered indexes -...

Not 100% sure so I preffer to shut up rather than give bad info.

I know tempdb has 1 gazillion different uses (that's an actual number ;-)). What I don't...

what extra info do you need on spaceused???

For all dbs, all tables this is something that would work, but I would definitely use Jason's script. It has a lot...

Very detailed version...

http://jasonbrimhall.info/2010/05/19/tablespace-update/

ok, officially stepping aside from this discussion.