If it's a select, you'll still get schema stability locks. If it's any form of modification, the nolock will be ignored. Data modifications have to lock.

Why nolock?

See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

Threads once posted can't be deleted.

Actual thread here - http://www.sqlservercentral.com/Forums/Topic722641-1550-1.aspx

Check it's documentation to see if you can find what that's measuring in. It may be bytes, disk sectors, SQL pages, or a...

<sigh>

"I detached the DB, deleted the log file and it won't attach. Backups not working either"

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=126304

Head-desk

Why???????????

If a database is detached while in the recovering or standby state, it cannot be reattached (baring some odd hacks that may or may not work)

In fact, in SQL 2008,...

Which SQL tool?

That's a heap (table that doesn't have a clustered index). It can't be defragmented because there's no index there to defragment.

Where are you measuring those IOs from?

How big are the indexes that aren't defragmenting? How many pages?

Bear in mind that all costs are estimates, no matter whether it's an estimated or actual plan. There are a number of factors that could make them wrong.

Will look at...

RBarryYoung (5/22/2009)

---

That's Kevin Boles. He's a might be a bit dismissive at times, but he doesn't usually go off on someone like that. I'd suggest trying to give...

Didn't really have many choices at the time.

SQL 2000 on Itanium. Critical production system (stock market trading). SQL completely unresponsive,...

Fortunately, as long as the log and data files are intact, that usually doesn't cause...

I'm curious. What's in index physical stats that you're using to determine the best clustered index?

These errors are the result of someone directly editing the system tables on SQL 2000. They are not the result of the upgrade.

In SQL 2000, CheckDB did not include...