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...
Sur cette page du site, vous pouvez voir la vidéo en ligne How to Delete Huge Data from a SQL Server Table in Small Chunks - SQL Server / TSQL Tutorial durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur TechBrothersIT 23 mars 2015, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 24,665 fois et il a aimé 137 téléspectateurs. Bon visionnage!
