It shouldn't contribute to the logical fragmentation. That's defined...

Is the min and max memory set to the same value? If so, please change that, there's a problem whereby if they are identical then some of SQL's memory management...

Main perf problem is that indexes on an encrypted column are useless. The encryption routines are no deterministic and so you can't encrypt a value and compare with the encrypted...

Very strange.

Are there any common traits about the slow iterations? Certain user, certain time, certain parameters?

Then you're about 90% safe to drop the indexes that the tuning wizard doesn't want.

Not unless you have some form of auditing in place already.

Did someone perhaps delete and recreate the 'object'? If you have cascading delete, that may have caused it.

*RotFL* :hehe:

Are you completely certain that the trace you have given the tuning wizard contains every single query that gets run against your SQl server, including any regular batch processes, month...

How much memory on the server? What's SQL's max memory set to? Are there other apps on the server?

I generally don't recommend that index tuning be done on an entire database at once. Too much opportunity for something to go wrong. i perfer to either tune indexes one...

Yes, however...

@@Error is set by every statement to the error that statement threw, or 0 if no error occured. In your example, if doSomething1 or DoSomething2 threw an error, you...

You can get just the user tables that have clustered indexes with this:

Select object_name(id), name From sysobjects Where xtype = 'u' AND objectproperty(id,'TableHasClustIndex')=1

and the user tables that don't have a...

Rather have a scheduled task that connects to the instance via windows authentication and runs the backup database task. Or create a login that only have permission to backup the...

Exactly what I'm using.

It's a pity. I want to like the 2008 intellisense, but it's irritating me. I can't find a way to change what triggers an auto complete,...

Please post this as a new thread in the SQL Server 2000 administration forum.