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...

Having recently done the same thing (and still in progress)

Here are some useful scripts:

Script 1 - determine LOBs per filegroup

select fg=filegroup_name(a.data_space_id), tbl=object_name(p.object_id), idx=i.name

from sys.allocation_units a

inner join sys.partitions p

on p.partition_id =...

Why does it concern you? You may have moved all the user database objects out of the Primary filegroup, but that is where the system database objects reside, and...