Viewing 4 posts - 1 through 4 (of 4 total)
If you are only swapping out partitions, and then splitting - i.e. not swapping in the data (and indexes!) to the new partition then the indexes for that partition will...
September 2, 2011 at 9:06 am
I build an empty table and create the relevant indexes on that filegroup and switch it into the newly created partition (after splitting). Even though I don't switch any data...
August 22, 2011 at 2:30 am
If you need the guid generated outside of SQL Server then you will have to create a sequential guid yourself. In your case this is because you need to insert...
August 10, 2011 at 1:58 am
I'm also running into this issue - did you find any solution please?
Maybe building the index on the empty partition just after the split using ON PARTITION will force...
August 9, 2011 at 8:10 am
Viewing 4 posts - 1 through 4 (of 4 total)