Monthly Archives: May 2011

SQL University – Internals and Deletes

Happy Friday everyone!  Today’s post is the third and final for SQL University’s Internals week.  Thank you to those of you that have been reading this week, it has been an honor to contribute to SQLU – thanks Jorge! ( blog | @sqlchicken ) For this last post I want to discuss the physical effects…

PSA: Summit Polls Close Tomorrow!

Tomorrow, Friday May 20th, is the last day to vote for any sessions you want to see at the PASS Summit this October.  In my usual last-minute manner, I thought I’d provide a link to the sessions I submitted for readers to review.  In addition, I’ve included a link for the session submitted by Adam…

SQL University – Internals and Updates

It’s Wednesday which means it’s time for the second post in the Internals series for SQL University this week.  On Monday we started off with a review of data structures for a database.  Today we are keeping with the data structures topic, but looking way under the covers at what happens when you update data. …

SQL University – Internals by the Numbers

Hello everyone, and welcome to Internals week of the 2011 Spring semester of SQL University.  I am Erin Stellato and I will be your professor this week. When you think Internals, what comes to mind?  It could be any number of topics…  The Storage Engine, the Optimizer, SQLOS, Buffer Cache – I could go on,…