Hey, Sorry for the long delay in posts, the usual, life getting in the way! But I recently had what to me seemed an obscure problem (although in hindsight, duh), but turned out to be caused by out of date statistics (Big thanks to Brent Ozar for the assist twitter | blog). The Problem To […]
Hey, It’s quite a well known fact that indexes can be good for your queries. They offer a shorter route to your data, and take some load off your server. They achieve this by creating a Balanced Tree (B-Tree) with pointers to your data. So in a table with customer names, if you search for
Today I’m going to move on to part 3 (of 4) of explaining the Maintenance Plan Wizard. Here’s a picture of the layout again, just in case you forgot!So today we’ll start with:Update StatisticsSo first, what are statistics. Statistics are SQL Servers internal information which it uses to make sure that your Query Plans are
Introduction to the Maintenance Plan Wizard – Part 3 Read More »
