Browse by Tags

• internals
• maintenance
• partitioning

• File Layout Viewer vs. Drop Clustered Index

  I had a very educational exchange the other day on Twitter (also known as “getting schooled”) by my SQL compatriots Argenis Fernandez (@DBArgenis) and Hugo Kornelis (@Hugo_Kornelis). A guy called Chris Switalski (@crswit) asked a really interesting question Read More... Posted Monday, June 03, 2013 12:41 AM by merrillaldrich | 1 Comments Filed under: indexes, storage, internals

• Public Release, SQL Server File Layout Viewer

  Version 1.0 is Now Available! Edit 9 October 2013: A new version is out! Please download 1.2 from here . 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 Read More... Posted Friday, March 01, 2013 2:36 PM by merrillaldrich | 14 Comments Filed under: partitioning, indexes, storage, internals Attachment(s): SQLFileLayoutViewerR1.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: maintenance, indexes, storage, internals

• 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 | 3 Comments Filed under: maintenance, indexes, storage, internals

• 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: maintenance, indexes, storage, internals