I have a table with about 200,000 records. so last week i decided to reduce the size to optimize performance so i backed up the table using
Code:
 select *into table_1 from table
after few days, i needed to restore data that has been deleted, so i renamed the tables
table_1 to table
and
table to table_1
then did a query to insert the the newly added records and consolidate both tables
Code:
insert into table  (a,b,c) select a,b,c from table_1 where datecreated > '02/08/2012'
Now that was all fine, but im just wondering if this would cause any indexing issues or corruptions. as i started to experiance performance and speed issues lately. i made sure there was no duplicates and ran
dbcc checktable ("products");
any suggestions ??