GabyYYZ (10/19/2009)
SanjayAttray (10/19/2009)
Very good question. I was asked this question in an interview.Q). What's the easiest and fastest way to move data of a table from file1 to file2?
A). Move the clustered index from file1 to file2.
Why would that be faster than say, creating a target table on file2 and inserting all into it from the source table?
I suppose part of the question was easiest and fastest...
Otherwise nice questions after all.