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

Publicado el: 23 marzo 2015
en el 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...

En esta página del sitio puede ver el video en línea How to Delete Huge Data from a SQL Server Table in Small Chunks - SQL Server / TSQL Tutorial de Duración hora minuto segunda en buena calidad , que subió el usuario TechBrothersIT 23 marzo 2015, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 24,665 veces y le gustó 137 a los espectadores. Disfruta viendo!

3,223

127