• Here is the build script:

    CREATE TABLE [dbo].[item](

    [item_urn] [int] NOT NULL,

    [cat_urn] [int] NOT NULL,

    [item_mnc] [varchar](10) NOT NULL,

    [item_descr] [varchar](50) NULL,

    [item_active] [char](1) NULL,

    [item_device] [varchar](20) NULL,

    [item_type] [char](1) NULL,

    [dept_urn] [int] NULL,

    [modified_by] [varchar](16) NULL,

    [mod_timestamp] [datetime] NULL,

    [mnc_descr_mod] [char](1) NULL,

    [man_urn] [int] NULL,

    [emp_urn] [int] NULL,

    [link_type] [char](1) NULL,

    [link_urn] [int] NULL,

    [mod_timestamp_server] [datetime] NULL

    ) ON [PRIMARY]

    SET ANSI_PADDING OFF

    ALTER TABLE [dbo].[item] ADD [inspd_loc] [char](1) NULL

    ALTER TABLE [dbo].[item] ADD CONSTRAINT [PK_item] PRIMARY KEY CLUSTERED

    (

    [item_urn] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]

    This is a vendor's table so I don't have control of the definition...

    Here are the results from the DMV:

    index_type_descalloc_unit_type_descindex_depthindex_levelavg_fragmentation_in_percentfragment_countavg_fragment_size_in_pagespage_countavg_page_space_used_in_percentrecord_countghost_record_countversion_ghost_record_countmin_record_size_in_bytesmax_record_size_in_bytesavg_record_size_in_bytesforwarded_record_count

    CLUSTERED INDEXIN_ROW_DATA2016.6666666723679.98312333680090123103.584NULL

    CLUSTERED INDEXIN_ROW_DATA2101110.938967136600111111NULL

    Google Doc with Results