This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL Server Deadlock: Build One With Your Own Hands

SQL Server Deadlock: Build One With Your Own Hands

August 4, 2026
Pinal Dave
SQL Performance
Deadlock, SQL Server

A SQL Server deadlock occurs when sessions form a cycle of dependencies and none can continue. This example lets you create the cycle, inspect it, and remove it.

Read More
Visual representation of database health check.

Database Performance Health Check: Six Months Slow, Fixed in 75 Minutes

July 21, 2026
Pinal Dave
SQL Performance
Comprehensive Database Performance Health Check, SQL Wait Stats

Six months of slow SQL, fixed in 75 minutes. See what a database performance health check finds, and how one focused 4-hour session ends the guessing.

Read More
SQL Server Execution Plan.

SQL SERVER – Execution Plans and Indexing Strategies – Quick Guide

February 9, 2026
Pinal Dave
SQL Performance
Clustered Index, Execution Plan, Query Hint, SQL Index

Let us learn today in this quick guide Execution Plans and Indexing Strategies. Your comments are welcome

Read More
A cartoon server room with a robot and a beach chair.

SQL SERVER and AI – Setting Up an MCP Server for Natural Language Tuning

October 27, 2025
Pinal Dave
SQL Performance
AI

Let us learn more about SQL SERVER and AI – Setting Up an MCP Server for Natural Language Tuning. Detailed Instructions.

Read More
JSON vs XML

SQL SERVER Performance – JSON vs XML

August 26, 2025
Pinal Dave
SQL Performance
JSON, SQL XML

What started as a simple recommendation turned into a comprehensive benchmarking exercise. Let us see blog post about JSON vs XML.

Read More
Farmers running down road with query performance train.

SQL SERVER Performance: When MAXDOP = 1 Slowed Down the Entire Business

July 25, 2025
Pinal Dave
SQL Performance
Comprehensive Database Performance Health Check, MAXDOP, SQL CPU, SQL Wait Stats

Slow reports, slow transactions, and the internal team could not find why. In this case study, MAXDOP = 1 was quietly slowing down the entire business.

Read More
Catching Non-SARGable Queries in Action.

SQL SERVER – Catching Non-SARGable Queries in Action

April 23, 2025
Pinal Dave
SQL Performance
Clustered Index, Execution Plan, Performance Schema, SQL Index

If you ever wondered why a query that looks harmless is performing poorly despite having indexes in place, the answer could non-SARGable queries.

Read More
Previous 1 2 3 4 5 6 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com