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
Quick question: Where would you go to find some basil in your local grocery store? Did you say “by the other herbs?” Or did you say “by the tomatoes?” If you are like me, then you would go looking for basil by the other herbs because, well, that is a natural, logical grouping of products. … Read more
I’ve written before about how much I love looking for outliers. One example of this can be found in the post I did on the sysjobhistory table. Recently I was asked to put together some code to find out which backups were “running long”. Of course my first question was trying to define what was … Read more
You have no idea that what you are not doing is causing you pain. Then again, how could you know this? I mean, if you are not doing it, why would you ever think that your inaction could be the very thing that is causing you heartache every time your phone rings in the middle … Read more
Last week I posted a puzzle of sorts. I showed you a handful of graphs from PAL and asked if anyone could determine what had happened. Out of all the comments that were left only a handful of people seemed to be on the right track, or showed a methodology in their thinking that should … Read more
Saw this review today and wanted to share it with everyone here: http://www.mikefal.net/2012/01/03/dba-survivor-learning-how-to-rock-out-with-databases/ I’m touched that Mike would take the time to write such a wonderful (and unsolicited) review of “that little book” I wrote almost two years ago now. I’d like for you to read his entire review, but I am going to share … Read more
