Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345

Clustered Index Internals Expand / Collapse
Author
Message
Posted Saturday, March 20, 2010 10:17 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:04 PM
Points: 11,168, Visits: 10,933
Peter Trast (3/20/2010)
Maybe if the data were not previously PARTITIONED, yes, but an assumption not in the question. The clustered index existed before as stated in the question so if both the clustered index and partition scheme were in place previously, data would not move.... anyone say different, please explain... please! :)
Oh I don't know...maybe the MOVE TO clause of DROP INDEX was used? In general though, you are right.

[quote]And, yes, you said that before but I have found it is best just to participate in the discussion without being terribly critical :) Point out specific errors, yes, but never generalize, as in using terms like "terrible", just hurts feelings. Everyone gets a chance to be incorrect now and then. After all, "it depends" is the number one phrase that I associate with SQL...

That's fine. I do not often use such words, but I felt it appropriate to do so here. Each to their own.




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #887024
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse