Does this skill provide missing index recommendations?

Yes, it includes specific queries to leverage SQL Server Dynamic Management Views (DMVs) to identify missing index recommendations with high impact scores.

Can it help with Columnstore indexes?

Absolutely. It covers both clustered and nonclustered columnstore index patterns, specifically tailored for high-performance analytics and hybrid OLTP workloads.

How does this skill improve SQL Server performance?

It provides expert-level strategies for index design, helping reduce query execution time and disk I/O through optimized data access paths and covering index patterns.

Does it support index maintenance tasks?

Yes, it includes guidelines and SQL scripts for monitoring index fragmentation and choosing between REORGANIZE and REBUILD operations based on best practices.

T-SQL Index Strategies

Name: T-SQL Index Strategies
Author: JosiahSiegel

byJosiahSiegel

•

데이터베이스 관리

Optimizes SQL Server database performance through expert index design, selection, and maintenance strategies.

소개

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.

주요 기능

Expert clustered and nonclustered index selection guidelines
Columnstore optimization patterns for analytical workloads
7 GitHub stars
Performance monitoring using DMVs and missing index statistics
Index maintenance scripts for fragmentation management
Composite key design and covering index implementation

사용 사례

Architecting data warehouse storage using clustered columnstore indexes
Automating database maintenance routines and statistic updates
Resolving query performance bottlenecks through strategic index design

소개

주요 기능

Expert clustered and nonclustered index selection guidelines
Columnstore optimization patterns for analytical workloads
7 GitHub stars
Performance monitoring using DMVs and missing index statistics
Index maintenance scripts for fragmentation management
Composite key design and covering index implementation

사용 사례

Architecting data warehouse storage using clustered columnstore indexes
Automating database maintenance routines and statistic updates
Resolving query performance bottlenecks through strategic index design