THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » backup » indexes » Maintenance   (RSS)
  • March Update to Rules-Driven Maintenance

    This month I have a minor update to the Rules-Driven Maintenance code I originally posted back in August 2012. This update has just two enhancements, but they are nice ones, I think: Much improved handling for instances that use database snapshots. Ability to do intra-day differential backups purely by setting maintenance times and limits ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on March 11, 2013
  • Update to Rules-Driven Maintenance

    Back in August I posted a first version of a rules-driven solution for backups, index and statistics maintenance and integrity checks. The system in general has been working well, and has saved my team a huge amount of time and effort. We are coming to the anniversary of its use in production soon. Today I offer an update that contains a few ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on January 16, 2013
  • Ola Hallengren's maint procedures now supports exclusions

    Ola has a set of stored procedures to do maint operations, see http://ola.hallengren.com/. Ola has now updated them to support exclusions or inclusions of tables, indexes or even whole schemas from index rebuild/reorg. Check out http://ola.hallengren.com/Documentation.html#SelectingIndexes for info on how to define exclusions and ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 9, 2010
Privacy Statement