HomeНаука и техникаRelated VideosMore From: TechBrothersIT

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

24 ratings | 9111 views
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/how-to-delete-huge-data-from-sql-server.html
Html code for embedding videos on your blog
Text Comments (1)
Tecno White (1 year ago)
did you already take a full backup?

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.