Eliminating Legacy Cursors: An AI-Assisted Deep Dive
A deep dive into decomposing complex legacy cursors with AI using the bulk-first, loop-for-side-effects pattern.
Diagnosing Parameter Sniffing with AI
Use AI to analyze execution plan XML, identify sniffed values, and evaluate RECOMPILE, OPTIMIZE FOR, and PSP optimization.
Eliminating Cursors with AI-Generated Set-Based Alternatives
Feed a cursor-based procedure to AI and get a set-based rewrite with honest advice about when cursors are still right.
Writing Window Functions with an AI Partner
AI agents write complex window functions faster than you can look up the frame clause syntax.
Converting Implicit Joins to ANSI Syntax with AI
Use an AI agent to convert legacy implicit joins to ANSI JOIN syntax safely.
Writing T-SQL with an AI Partner
Use AI to write T-SQL faster generating functions, complex JOINs, window functions, and optimization suggestions. Practical prompts for real DBA work.