Tag: Transaction Log

Deferred-drop tipping point
By Art on May 31, 2014

I was intrigued by the deferred-drop feature that has been inside SQL since SQL Server 2000 SP3 after watching one of Paul Randal’s Pluralsight courses which was ‘Logging, Recovery and the Transaction Log’. The deferred drop feature is what allows for the seemingly instant truncation or drop of any table regardless of how big the table is. I wanted to […]

Read More
Tags
Admin Azure backup Blogging Bug C# Career CDC Certification Collations Command Line Comments Configuration Connect Consulting CU Cursor DBA DDL delete Disaster Recovery Disks DMV DR Execution Plans Facebook FIGlet FileTable Firewall Flwor Fun Hack Indexes Internals modify() Performance query() Script Service Broker SQL 2012 SQLBits SQLCLR Training Views VM Xml XML DML Xml Functions XPath XQuery
Categories
Uncategorised (61)