We all know that statistics get updated when you rebuild your indexes, right? OK, for those of you that are not aware of such things here is a blog post from Benjamin Nevarez (blog | @BenjaminNevarez) on the topic. He does a great job of explaining the subtle differences involved with various index and statistics … Read more
This is the last post in my series on SQL Server system tables. I have enjoyed writing these posts for the past 19 days and I might be persuaded into doing something similar in the future but only if I can find a way to make it more unique than just following a calendar. If … Read more
Ever feel the need to dig through the details regarding your database backups? Well today is your lucky day! I will show you a few details regarding the msdb..backupset table. What is this table for? This table will contain one row for each successful backup set, which is the same as saying it contains one … Read more
Ever wonder about the history of the jobs that exist inside of SQL Agent? Sure, you could navigate to ‘Jobs’ folder, right-click, then select ‘View History’ and get a nice view of the history for all the jobs. But is that sufficient? Are you confident that the history viewer will give you all of the … Read more
Did you ever wonder how SQL Server keeps track of the jobs created inside of the SQL Server Agent? No? Well, neither did I until I became a DBA and noticed just how easy it is for someone to create a job inside of SQL Agent. You might be saying “Tom, what’s wrong with that?” … Read more
I am taking a bit of a right turn with this post and subsequent ones for this series. I am heading into the msdb database from here on out. I am doing this for two reasons: because there is less than a week left in the series and because these tables inside of the msdb … Read more
