Contents tagged with Internals

  • 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 regardless of how big the table is. I wanted to find out a little more about it so after a quick Google, the number one result was this blog post from Paul which goes into the …

  • SQLBits XI - My second most eagerly awaited event of 2013...

    I bet you are half wondering what is the first? Well that would be the birth of my second child which due in March so you could say that SQLBits XI is my most “professional” eagerly awaited event of 2013.

    Last Friday I was just about to head off to get some lunch at around 12 and I just happened to look up at my emails and saw the email that I had been waiting weeks to see. That was the email saying that SQLBits registrations has now opened. I didn’t hang around at this point. …