It depends on the numbers for each column of your index, the way they are spread over your total of rows.

Most of the time, PK-columns are just pointed for their...

Try to use MAXDOP(1) queryhint. Maybe you're experiencing multiprocessors problems

from BOL:

MAXDOP number

Overrides the max degree of parallelism configuration option...

I already was addicted to it !

I'ts _the_ chance of the year to get good technical input, meet other people doing about the same thing as you are, but maybe...

Yep, there were many of us

Well, there were +100 persentations so making a choice was a task by itself !

All my days were...

Is it me misinterpreting things, or is this going way back in time

PASS was a thrill !

5 days of dumping new features ,...

my first screenshot costed $400 for the screen and 25ct for the bullet

I allready ordered an "extra wide screen" to put all the little yellow workaround reminders

Aaarch .... It works ...

Now I hope I get used to work with this workaround

Thanks

well .....  a search for "ssc alzdba" did not return any results at all

a search for "msdtc alzdba" also did return zip

for what I tested that only worked where the name was stated in the text-zone of a reply

Warning : this query does direct access to system-objects ! They may change without warning with hotfix, sp, ...

This is what I use...

start with :

ALTER DATABASE yourdb Set RESTRICTED_USER , read_only WITH ROLLBACK IMMEDIATE

Restore database yourdb from .....

check your backup with

RESTORE LABELONLY

FROM disk=yourbackup-file

RESTORE HEADERONLY

FROM disk=yourbackup-file

and check the creation dates !

I guess you have restored an older version of master !

how about trying :

alter database yourdb set online