Your xml format is not very well organized. Keys and children are not in any relation except positional, so it is almost impossible to relate them.

You should make children of...

Here are some links that might help:

http://msdn.microsoft.com/en-us/library/ms190030%28v=sql.105%29.aspx

SEND queue, REDO queue from performance counters:

http://www.mssqltips.com/sqlservertip/2228/sql-server-database-mirroring-performance-monitoring/[/url]

http://sqltwist.com/archives/179

Estimate space gain with sp_estimate_data_compression_savings procedure:

exec sp_estimate_data_compression_savings 'myschema', 'mytable', 1, NULL, 'none'

exec sp_estimate_data_compression_savings 'myschema', 'mytable', 1, NULL, 'row'

exec sp_estimate_data_compression_savings 'myschema', 'mytable', 1, NULL, 'page'

With compression = none you check savings...

You don't. You should monitor your log on both principal and mirror, is agent that applies the log on the mirror working, and state of the mirroring session. Investigate the...

There is row-level compression and page-level compression (stronger and slower). If you compress clustered index, in fact you compress the table. PK does not have to be the same as...

ROUND function has optional third parameter which can specify truncation instead of rounding. This will give you the result you want:

UPDATE #Analysis

SET AccMargin = ROUND(Margin/Gallons + Freight/Gallons, 6, 1)

IDMarginGallonsFreightAccMargin

10.0502205022-30.180000-0.005999

20.050220-5022318.260000-0.063383

If you...

Yes

No, you don't have to add DID column to the index and it does not have to be unique.

If your...

Use sqlcmd variables. Here are some examples:

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/3031a9fd-f3de-4482-b8f6-67f033300ae8/

http://msdn.microsoft.com/en-us/library/ms188714.aspx

Check estimated execution plan of your "delete A" command. Does it SCAN or SEEK table D ? If it SCANs, you probably have no right index.

Don't drop or disable constraints....

tshad (3/1/2013)

---

I am deleting the referenced records first, so if I just disable that table do the deletes then reenable the FK then all should be well?

Is there a way...

One option is to lower the fill factor, so future rebuilds will be needed rarely. Default fill factor of 0 (0 or 100 means 100% full pages) guarantees fragmentation will...

Kill a command is not something you plan, but you should be aware that rollback is expensive, depending on how much transaction log is generated. What recovery model db is...

It's a complex topic.

Encrypt values of sensitive columns with symmetric-key encryption (cell-level encryption).

Use Transparent Database Encryption to encrypt files (data files, log files, and backup files).

Additionally, you could use "WITH...