What platforms are supported by this skill?

This skill is specifically tailored for Microsoft SQL Server (all versions) and Azure SQL Database (Singleton, Elastic Pool, and Managed Instance).

How does this skill help with SARGability?

It identifies patterns like using functions on columns in WHERE clauses that prevent index seeks and suggests equivalent, index-friendly T-SQL syntax.

Can it help with SQL Server 2022 features?

Yes, it includes guidance on modern features like Parameter Sensitive Plan (PSP) optimization and Query Store hints for SQL Server 2022 and Azure SQL.

Can it identify missing indexes in my database?

Yes, it provides specific DMV-based queries to identify missing indexes with the highest potential impact on your system performance.

Does this skill provide solutions for Parameter Sniffing?

It provides multiple proven strategies including OPTION (RECOMPILE), local variables, and OPTIMIZE FOR hints to stabilize query performance.

T-SQL Query Optimization

Name: T-SQL Query Optimization
Author: JosiahSiegel

byJosiahSiegel

•

데이터베이스 관리

Optimizes SQL Server and Azure SQL Database performance through advanced T-SQL query tuning and execution plan analysis.

소개

This skill empowers Claude to identify and resolve performance bottlenecks in T-SQL environments by applying industry-standard optimization techniques. It provides expert guidance on transforming non-SARGable patterns into index-friendly queries, resolving parameter sniffing issues, and interpreting complex execution plans. Whether you are working with legacy on-prem SQL Server or modern Azure SQL Databases, this skill helps you implement efficient joins, manage statistics, and leverage query hints to ensure high-performance data retrieval and minimal resource consumption.

주요 기능

Prevents performance degradation caused by implicit data type conversions
Identifies and rewrites non-SARGable queries to enable efficient index seeks
Resolves parameter sniffing issues using RECOMPILE, OPTIMIZE FOR, and PSP techniques
Analyzes execution plans to detect costly operations like Table Scans and Key Lookups
7 GitHub stars
Provides automated scripts for statistics management and missing index identification

사용 사례

Implementing covering index strategies to eliminate expensive bookmark lookups
Diagnosing and fixing intermittent performance drops caused by unstable execution plans
Refactoring slow-running legacy T-SQL queries to improve application response times

소개

주요 기능

Prevents performance degradation caused by implicit data type conversions
Identifies and rewrites non-SARGable queries to enable efficient index seeks
Resolves parameter sniffing issues using RECOMPILE, OPTIMIZE FOR, and PSP techniques
Analyzes execution plans to detect costly operations like Table Scans and Key Lookups
7 GitHub stars
Provides automated scripts for statistics management and missing index identification

사용 사례

Implementing covering index strategies to eliminate expensive bookmark lookups
Diagnosing and fixing intermittent performance drops caused by unstable execution plans
Refactoring slow-running legacy T-SQL queries to improve application response times