How to Delete Huge Data from a SQL Server Table in Small Chunks - SQL Server / TSQL Tutorial

Published: 23 March 2015
on channel: TechBrothersIT

24,665

137

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...

On this page of the site you can watch the video online How to Delete Huge Data from a SQL Server Table in Small Chunks - SQL Server / TSQL Tutorial with a duration of hours minute second in good quality, which was uploaded by the user TechBrothersIT 23 March 2015, share the link with friends and acquaintances, this video has already been watched 24,665 times on youtube and it was liked by 137 viewers. Enjoy your viewing!