GitHub

Script for analyzing SQL Server index structure and filegroup usage

This SQL script provides a detailed view of index allocation, filegroup usage, and physical storage for user tables in any SQL Server database. It's a valuable tool for DBAs and data engineers aiming ...
GitHub

Index#: find duplicate indexes.sql

THEN 'IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N''' + TableName + ''') AND name = N''' + IndexName1 + ''') columnname = c.name, is_descending ...