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. …
Continue Reading »
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,…
Continue Reading »
May is slated to be a busy month for me, and the first week did not disappoint. This week I: ordered some books on time management signed up for a SQLskills training class finished and submitted abstracts for the PASS Summit Reading List You might be thinking, “Really Erin? You’re blogging about ordering some books?”…
Continue Reading »
Last month Thomas LaRock ( blog | @SQLRockstar ) started a series called Meme Monday, and this week the task is to list nine things that can wrong with SQL Server that are not the result of an issue with the database file storage. Note: The emphasis on nine reminds me of a quote from…
Continue Reading »