Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server Rocks!

SQL Database Administrator/Developer. Background in developing OLTP/document based databases, SQLXML and performance tuning with an unhealthy fascination for the SQL query optimiser!

Archives: May 2014

Deferred-drop tipping point

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ā€¦ Read more

0 comments, 193 reads

Posted in SQL Server Rocks! on 31 May 2014