Regarding the index definitions and online processing. I am aware of the restrictions and have code to process those indexes only in ONLINE = NO mode.

The technical paper has a...

OK, but ONLINE = ON and SORT_IN_TEMPDB = ON does sound like a valid combination that someone would want to try to improve performance. Even the Technical Paper does not...

Is this statement correct. If you have a maintenance process that rebuilds indexes and then another process that will calculate and rebuild stats, should autostats be turned off?

I am connected to all three instances using SMS and logged in with the same account. There are no issues there. My problem is connecting the witness server to the...

I am running 3 instances of the developer ediditon on the same machine. All are running under the same service account and are patched to version 9.00.3073. It is a...

has anyone had any success setting up a mirroring environment on a standalone machine running vista and SQL Developer editions. I am able to set up the principal and the...

Paul,

Thank you for responding, Your comments are very much appreciated

the tables are getting very large, over 500 million rows in orderdetails. Would like to archive, but client does not want it at this time. Figurred partitioning would hopefully rreduce...

I agree with the remark below. If you modify indexes, other queries may now perform poorly. It is just a tip of the iceberg.

In theory, you have a primary key...

quote:

---

In theory, you have a primary key there for a reason. If the question had given more information as to the purpose...