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

Publicado em: 23 Março 2015
no canal de: 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...

Nesta página do site você pode assistir ao vídeo on-line How to Delete Huge Data from a SQL Server Table in Small Chunks - SQL Server / TSQL Tutorial duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário TechBrothersIT 23 Março 2015, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 24,665 vezes e gostou 137 espectadores. Boa visualização!

3,223

127