Delete Statement on Fact table (Transaction data table)

• sudhirnune

  SSCrazy

  Points: 2342

  More actions

  May 16, 2013 at 11:27 am

  #277690

  Hi All,

  I have a Transaction Data holding table, which has data around 10 to 20 Million rows.

  Now the problem, is that we need to delete and load the data occasionally based on Time Period of the Data.

  which will be around 1 million records.

  please need your help and suggestion, how to make this table feasible for this operating and does not effect the performance.

  All ideas are appreciated, please need help.

• Neeraj Dwivedi

  SSCertifiable

  Points: 6768

  More actions

  May 16, 2013 at 11:44 am

  #1615935

  Read through this. Very nice article by Gail Shaw.

  https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/