Browse by Tags

• backup
• internals
• productivity
• statistics
• storage
• tools

• October Update to Rules-Driven Maintenance

  Happy Fall! It’s a beautiful October here in Minneapolis / Saint Paul. In preparation for my home town SQL Saturday this weekend, as well as the PASS Summit, I offer an update to the Rules-Driven Maintenance code I originally published back in August Read More... Posted Wednesday, October 09, 2013 5:19 PM by merrillaldrich | 5 Comments Filed under: indexes, maintenance, statistics Attachment(s): RulesMaintenanceV1_3.zip

• 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 Read More... Posted Monday, March 11, 2013 8:56 PM by merrillaldrich | 3 Comments Filed under: backup, indexes, maintenance, productivity Attachment(s): RulesMaintenanceV1_2.zip

• Visualizing Data File Layout III

  This is part three of a blog series illustrating a method to render the file structure of a SQL Server database into a graphic visualization. Previous Installments: Part 1 Part 2 Those that have been reading this series might be be thinking, “Is he going Read More... Posted Monday, January 28, 2013 10:45 PM by merrillaldrich | 5 Comments Filed under: indexes, internals, maintenance, storage

• Visualizing Data File Layout II

  Part 2 of a blog series visually demonstrating the layout of objects on data pages in SQL Server Part 1 In Part 1 of this series, I introduced a little demo app that renders the layout of pages in SQL Server files by object. Today I’ll put that app through Read More... Posted Wednesday, January 23, 2013 4:40 PM by merrillaldrich | 4 Comments Filed under: indexes, internals, maintenance, storage

• Visualizing Data File Layout I

  Part 1 of a blog series visually demonstrating the layout of objects on data pages in SQL Server Some years ago a gentleman called Danny Gould created a free tool called Internals Viewer for SQL Server . I’m a visual sort of guy, and I always thought Read More... Posted Tuesday, January 22, 2013 3:50 PM by merrillaldrich | 7 Comments Filed under: indexes, internals, maintenance, storage

• 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 Read More... Posted Wednesday, January 16, 2013 11:34 AM by merrillaldrich | 0 Comments Filed under: backup, indexes, maintenance, productivity, tools Attachment(s): RulesMaintenanceV1_1.zip