Jon Gurgul's Blog

Tag: FileGroup

  • Detailed Table Index Breakdown With Buffered

    —

    by

    Jon Gurgul
    in

    This script builds on the Detailed Table and Index script to further show the buffered metrics. This script will give you a comprehensive breakdown of your tables and indexes, which is shown with schema(s),table(s),index type(s),index size(s),row count(s) as well as the filegroup(s) and partition(s) information. Also in this script I have included two columns called…

  • Detailed Table and Index Breakdown

    —

    by

    Jon Gurgul
    in

    When I need to get a detailed overview of my database objects there are a number of scripts that I have written or adapted with varying degrees of depth. Primarily I wrote these scripts as a way to determine rough rowcounts,database and data/index sizes, but as I went I added more and more bits of information.…