When using detailed, you should only be worried about the bottom (data) level. I think you are fine for now.

So, that is showing us index level 4 - what are the values for the other index levels? And, where are you seeing that this table has millions of...

Can you provide a sample of what you are seeing when you use DETAILED? I am going to guess that you are seeing fragmentation at one of the leaf...

Was this database upgraded from SQL Server 2000? If so, have you run DBCC UPDATEUSAGE and DBCC CHECKDB ... WITH DATA_PURITY?

Since you are using the DETAILED flag, are you...

If your table is small - it will never be defragmented fully. How large is this table in pages?

The general rule is that you won't see any benefits to...

What version of SQL Server 2005 are you using? Earlier versions required SQL Server Agent Alert system to be configured before the Notify Operator task would work.

This was fixed...

First, if the variance column is always derived - then I would recommend creating a computed column instead of updating the value in that column. Example:

CREATE TABLE #DeriveVariance

(

ValueA INT,

ValueB...

mpv (7/7/2009)

---

The View works. My only concern is that two of my tables are in one DB and the third is in a different DB. Are there problems...

As long as you set the max memory for each instance so that you are not consuming all of the available memory and you have enough resources to support multiple...

Have you applied the patch found at: http://support.microsoft.com/kb/921106 yet?

What are you going to do with all columns and all 25 million rows? You can't possibly work with that much data.

The issue you outline here is not the only issue, nor in my opinion is it the worst case. The worst case is when you have data movement occuring...

You cannot backup the master database with a differential backup. You can only back up the master database with a full.

There is no reason to backup system databases with...

rob mcnicol (7/6/2009)

---

i am referring to processor allocation. we are happy with the information we have on licencing.

why is it that during a failover the...

I don't know whether or not you can upgrade from Workgroup to Enterprise. I guess you could try it and see what happens.

However, I don't think you really need...