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...
In questa pagina del sito puoi guardare il video online How to Delete Huge Data from a SQL Server Table in Small Chunks - SQL Server / TSQL Tutorial della durata di ore minuti seconda in buona qualità , che l'utente ha caricato TechBrothersIT 23 marzo 2015, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 24,665 volte e gli è piaciuto 137 spettatori. Buona visione!
