Bulk Delete failing
The author shares their experience with bulk deleting data from a large production instance of over 500GB. They attempted to remove over 5 million records using bulk delete, but it failed to complete the task due to SQL Timeout. The author suggests that bulk delete may not handle exceptions like SQL Timeout properly or may have a limit on the number of times it will retry. They also tried to remove the same records using SSIS/Kingswaysoft and received a SQL Timeout error. The author advises being cautious when using bulk delete in large instances and hopes that the functionality will be modernized soon.
Article 18m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time