I have to delete data from live table( Size of DB:terabytes) (system is becoming slow).
without affecting the end users ?
And tables have indexes and identity columns.( when I delete , I don't want to affect the identity columns, how can we do it?)
It is taking lot of time to delete the data.How can i do that?
Any steps to follow.