A Developer's Musings on SQL Server Administration

A developer's programmatic approach to SQL Server administrative tasks.

Saturday, January 25, 2025

Compare fragmentation before and after running a defrag routine

›
To compare fragmentation before and after running a defrag, you can use this code.  The vwFragmentation view contains NumPages, Rows, and ...
Saturday, December 28, 2024

vwFragmentation

›
This is a comprehensive view for fragmentation, together with size in bytes (from vwTable).   Keep in mind that when assessing fragmentati...
Monday, March 25, 2019

Table Size in rows and bytes - instance-wide

›
When troubleshooting disk I/O bottlenecks you may want to see what the largest tables are.  Rather than looking at rows, it is more importa...
›
Home
View web version

About Me

Paul Paiva
Colorado
Paul has 18 years experience with Microsoft SQL Server. He has worked in the roles of production DBA, database developer, database architect, applications developer, business intelligence and data warehouse developer, and instructor for students aspiring for MCDBA certification. He has performed numerous data migrations and supported large databases (3 Terabyte, 1+ billion rows) with high transactions. He is a member of PASS, blogs about lessons learned from a developer’s approach to SQL Server administration, and has been the president of the Boulder SQL Server Users’ Group for 11 years, from January 2009 to 2020.
View my complete profile
Powered by Blogger.