As Grant stated far more eloquently than I can, having the clustered index there may be causing you to split pages as the token is probably not a sequential id....

It does look cool. Very Oraclesque.... 😛

;

I don't actually run it either for a couple of reasons but it is more robust than intellisense. Due to the size of our environment I really can't use it...

When you try Intellisense you will find that it is not as robust as SQL Prompt. Of course that is opinion but you should still check it out prior to...

Nope, just with 2008 installs. The tools work great though and there are some benefits, like recommended indexes when looking at execution plans and you actually get flagged when there...

You stated that you have a dedicated pipe to the SAN but is it possible that the volume group (SAN level) in question is shared across more than one drive...

Yup, just making sure that there wasn't confusion between the two. Thanks for the clarification.

Just a note from BOL;

"Rebuilding a clustered index does not rebuild associated nonclustered indexes unless the keyword ALL is specified."

Thanks. That would be great. You can contact me directly by sending me an email via my profile information.

Thanks again!

Nice. Thanks for sharing and glad it worked.

We are doing a upgrade to 2008 on 64-Bit in a couple months and part of that is moving servers that are...

Curious as to what you were trying to do and what you ended up with as a functional solution. If you can post that it may help others in the...

I honestly don't know. Haven't tried it. I could try to test it in the next day or so but not immediately as I'm a wee bit busy lately.

Anyone...

No, I was referring to Mani's comment about having 2 servers. If that was possible then you could do the rename at the end. Sorry for the confusion.

Blocking is required for databases to function so no, there is no way to avoid it completely. 🙂 Your solution is definitely a possibility and probably pretty sound.

The other...

A couple of queries as follows;

--Help to isolate physical disk(s) that are involved in the I/O bottlenecks

select

db_name(t1.database_id) AS DatabaseName,

t1.database_id,

t1.file_id,

substring(mf.physical_name, 1, 2) as DriveLetter,...