• "Dropping a rebuilding a clustered index on a partition scheme will move disk to other drives." :w00t:

    Are you serious? What if I only have one disk (physical or logical (like in a SAN))? Where will it move? To Limbo or what?

    I would say that the answer is wrong, becuase data will only be moved to other drives if the partition scheme uses a File group that is placed on another drive.

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform