can you affort a dbcc dbreindex ?

Indexdefrag does not optimize as well as dbreindex.

Check the execution...

Correct.

so why have a fire insurance ? It's not burning right now

One part of a dba's job is to prevent (proactive) troubles.

That's...

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