Browse by Tags

• indexes
• internals
• powershell
• storage

• Public Release, SQL Server File Layout Viewer

  Version 1.0 is Now Available! I’ve been working off and on, as my real job permits, on this visualization tool for SQL Server data files. This is an educational or exploratory tool where you can more readily see how the individual data pages in MDF/NDF Read More... Posted Friday, March 01, 2013 2:36 PM by merrillaldrich | 9 Comments Filed under: partitioning, indexes, storage, internals Attachment(s): SQLFileLayoutViewerR1.zip

• Updated Warehouse Re-Index Script

  As I talked about in my last post , I just went through a re-indexing project that took the partitioned fact rows from our warehouse and relocated them into new files. There are a lot of tables and indexes involved, so I have a PowerShell “helper” script Read More... Posted Monday, January 14, 2013 5:30 PM by merrillaldrich | 1 Comments Filed under: powershell, partitioning