iqtedar (1/5/2010)

---

I have set the page count more than 1000 since it seems we need to worry only for indexes for which table size is atleat 8 Mb? So from...

It's not. The select has S and IS locks. Look at the owner list for which locks which process has and wants. The select has a page lock in mode...

Technically those two indexes are not duplicates. One enforces the primary key, one allows filter on two columns. Unless you have a good reason, I'd actually leave them.

Widening the pk...

Rough guess, same place as the leaf...

That is not necessarily true. There are ways to repair a SQL database with varying amounts of...

Please post SQL 2000 questions in the SQL 2000 forums in the future.

Please post table definitions, sample data and desired output. Read this to see the best way to post...

Please don't cross post. It just wastes peoples time and fragments replies.

No more replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic841706-150-1.aspx

If detailed has to be used, stick a where clause and filter for index level = 0

I wouldn't suggest that. Consider the case of an index with a 5-page intermediate level that's 80%...

In detailed mode there's a row for each level of the index. In limited there's only a row for the leaf level (level 0).

Since the intermediate levels are much smaller...

Well, you can't rebuild a heap, so fragmentation levels for that (which, btw are extent fragmentation not logical fragmentation) won't change with an index rebuild.

If you've got an average page...

Don't try to migrate the system tables. Not recommended, not a good idea.

If you're doing an in-place upgrade, the installer will take care of that. If you're doing another...

You may be able to remove both subqueries and just have one query with an OR in the join clause. (INNER JOIN <second table> ON <condition> OR <condition>). It'll look...

Grant Fritchey (1/5/2010)

---

My wife and I used to pay renters insurance when we lived in the city. People scoffed at us until the day we were broken into. They cleaned...

Are you returning different rows from the tables in each part? If so, it may be the easiest way of doing this.