How to Delete Huge Data from a SQL Server Table in Small Chunks - SQL Server / TSQL Tutorial
In this video you will learn how to delete large number of records from a SQL Server Table. By watch this video you will learn following topics
1--How to Delete large number of records from SQL Server Table in small chunks
2--What is the difference between Full Recovery Mode and Simple Recovery Mode
3--Does Transactional Log file grow if we set the database to Simple Recovery and Delete huge number or records?
4--How to get the record count while Transactions is deleting the records by using NoLock Option
5--How to Shrink Log file and release unused space to Operating System
6- How to write script to delete records in small chunks from SQL Server Table
Blog post link for scripts used in the video:
http://sqlage.blogspot.com/2015/03/ho...
На этой странице сайта вы можете посмотреть видео онлайн How to Delete Huge Data from a SQL Server Table in Small Chunks - SQL Server / TSQL Tutorial длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь TechBrothersIT 23 Март 2015, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 24,665 раз и оно понравилось 137 зрителям. Приятного просмотра!
