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…
Category Archives: Internals
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,…
