That reads out of the default trace.

If you're not trying to go too far back in time, it will work. The trace is limited to 5 files of 20...

What kind of 'batch processing'?

Sometimes SQL will parallel processes and sometimes it won't as there is an overhead in running stuff in parallel.

I don't believe this kind of info is kept historically, unless there's some custom monitoring in place.

That's as it's supposed to be.

Do you...

As I said above, I'd do checkDB first, as there's little point in trying to rebuild indexes of a database with corruption. Also, it's very likely that the index rebuild...

The equality/inequality refers to how the columns are used in the query that resulted in the missing index entry.

Generally, if you are going to use the missing index stats DMV...

It's not a SQL 2005-specific problem. The error (specifically the state) is saying that the database requested by the login isn't available, either because it's not there, is offline or...

What Brad is saying is that in active/active, you are running two difference instances, one on each node. It's not possible to run one instance on both nodes at the...

They'll have to have different names. Both instances are installed on both nodes, although they're only active on one at a time.

It's not unusual (in SP4 of SQL 2000) to see self-blocking. It's usually nothing to worry about. It may indicate parallelism or just that part of the query execution is...

Would you be willing to do a presentation via Live Meeting...

I know someone in that area. I'll drop him a note, see if he's interested.

Terri .K Wei (9/16/2008)

---

Would this be anything to do with table properties in sql2000? like example compatibility settings or any settings that needs to be checked to prevent such to...

I'd run it before. There's not much point in doing expensive maintenance on a database that's corrupt. If there's any corruption present, the reindex would probably throw errors anyway.

No impact other than that you will no longer be able to take log backup and hence will not be able to restore to a point-in-time after switching to simple....