Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
agupta16
Starting Member
3 Posts |
 Posted - 2012-04-04 : 12:36:11
|
| What is the best logic of implementing purge. We have a application having millions of records and we want to purge on the data basis. Please explain how purge works in DB. As per my understanding is when we purge it drop all indexes, re-org the table and do the index creation again. What all process goes in background and what is best performing solution.Amit Gupta |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-04 : 20:31:06
|
| do you mean purging entire data or a subset of it?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
agupta16
Starting Member
3 Posts |
Posted - 2012-04-05 : 01:42:07
|
| I want to purge subset of data based on date range.Amit Gupta |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-05 : 13:23:04
|
| then you need to write a delete logic based on date field. If dataset is large consider putting an index on datefield for speeding up delete------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Purge Logic