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

this microsoft provided link states that they were erroneous in which versions support automatic page repair.

both standard and Enterprise editions support it.

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

this microsoft provided link states that they were erroneous in which versions support automatic page repair.

both standard and Enterprise editions support it.

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

this microsoft provided link states that they were erroneous in which versions support automatic page repair.

both standard and Enterprise editions support it.

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

this microsoft provided link states that they were erroneous in which versions support automatic page repair.

both standard and Enterprise editions support it.

1. Disk volumes need to be defragged.

2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

1. Disk volumes need to be defragged.

2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

1. Disk volumes need to be defragged.

2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

1. Disk volumes need to be defragged.

2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

1. Disk volumes need to be defragged.

2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

1. Disk volumes need to be defragged.

2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

1. Disk volumes need to be defragged.

2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

1. Disk volumes need to be defragged.

2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

We use a similar setup for the explicit purpose of being able to easily move databases and instances from one server to another should the need arise.

I would recommend that...

I agree with Lynn on the NOLOCK hint. Too many places have mandated the NOLOCK on all Select statements. This is one that should have a proceed with...

Forgot to add to the post that DB optimization is not found in the filegroup solution alone - but can be a piece of the puzzle. In short, I...