1. Partition -- instead of select into ... use alter table switich partition
to move partition data.


alter table PartitionedTable switch partition partitionnr
to dumpPartitionedTable partition partitionnr


2. Data Compression -- Page level , Row level

3. DMV's

4. Dimensional modeling versus ER modeling -- Raphl Kimball

5. http://peddireddy999.blogspot.com/

1. Partition -- instead of select into ... use alter table switich partition
to move partition data.


alter table PartitionedTable switch partition partitionnr
to dumpPartitionedTable partition partitionnr


2. Data Compression -- Page level , Row level

3. DMV's

4. Dimensional modeling versus ER modeling -- Raphl Kimball

5. http://peddireddy999.blogspot.com/