July 2011 - Posts

• Index Optimization update from Ola Hallengren

  Ola has updated his index optimization scripts again. The update relates to logging to a table. You'll find the scripts here: http://ola.hallengren.com/ Read More... Posted Tuesday, July 19, 2011 2:17 PM by Greg Low | 0 Comments

• SolidQ Journal for July 2011 is out now

  Great to see SolidQ Journal for July now out the door. You'll find it here: http://www.solidq.com/sqj . Rushabh Mehta provides part 1 of an article on building an SSIS Management Framework. The framework helps to institute a methodology that puts standards Read More... Posted Friday, July 15, 2011 4:27 PM by Greg Low | 0 Comments

• Analysis Services - Usage Based Optimization - Unhelpful UI

  When using the Usage Based Optimization wizard (or the Aggregation Design Wizard), on the screen that asks you to enter counts. There is a button that says "Count" but after using it, you might still be confronted by the message ""Estimated Count or Partition Read More... Posted Wednesday, July 06, 2011 7:09 PM by Greg Low | 3 Comments