About
T-SQL Index Strategies is a specialized Claude Code skill designed to help developers and DBAs architect high-performance SQL Server databases. It provides deep technical guidance on choosing between clustered and nonclustered indexes, implementing columnstore storage for data warehousing, and creating efficient covering indexes to eliminate key lookups. Whether you are dealing with query performance bottlenecks or planning a new schema, this skill offers the implementation patterns, composite key ordering logic, and maintenance scripts needed to ensure optimal data retrieval and storage efficiency.
