Skip to main content

vince-winkintel/sql-server-skills

最近记录的来源活动
SkillsMP 收录数据更新
已收集 skills
8
GitHub 星标
2
GitHub Forks
0

用 AI 助手安装

复制这段 Prompt,发给你正在使用的 AI 助手。

正在加载仓库 README…

这个仓库中的 skills

1 个职业分类 · 已分类 13%

已展示 8 / 8 个已收集 Skill。

职业分类
未分类
描述

Comprehensive SQL Server performance diagnostics, index analysis, execution plan interpretation, query optimization, schema management, backup/restore, and monitoring using sqlcmd and T-SQL DMVs. Use when analyzing slow queries, investigating wait stats,…

原文语言:英语

更新
职业分类
未分类
描述

SQL Server backup and restore operations — full, differential, and log backups, RESTORE with NORECOVERY/RECOVERY, RESTORE VERIFYONLY, backup history queries, and recovery model guidance.

原文语言:英语

更新
职业分类
未分类
描述

Capture and interpret SQL Server execution plans. Identify bad operators (table scans, key lookups, hash spills), diagnose parameter sniffing, and act on row estimate discrepancies.

原文语言:英语

更新
职业分类
未分类
描述

SQL Server index management — find missing indexes, analyze fragmentation, identify unused indexes, design covering indexes, and understand index usage stats.

原文语言:英语

更新
职业分类
未分类
描述

SQL Server monitoring — SQL Agent jobs, error log, database health, blocking chains, deadlock analysis, long-running transactions, and disk space.

原文语言:英语

更新
职业分类
未分类
描述

Fix SQL Server stored procedures, views, and T-SQL anti-patterns. Covers non-SARGable predicates, implicit conversions, cursor replacement, DELETE+INSERT anti-pattern, CTE vs temp table decisions, and query hints.

原文语言:英语

更新
职业分类
未分类
描述

SQL Server DDL patterns — CREATE TABLE with proper data types, ALTER TABLE, idempotent migrations, foreign keys, computed columns, and check constraints.

原文语言:英语

更新
职业分类
数据库架构师
描述

Identify SQL Server performance bottlenecks using DMV queries. Covers wait stats, slow queries, active requests, performance counters, and connection analysis.

原文语言:英语

更新
已展示 8 / 8 个已收集 Skill。