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
Mar7

T-SQL Errors and Reactions Demo: SQL in Sixty Seconds #005

Pinal Dave
SQL Video
SQL Error Messages, SQL in Sixty Seconds, SQL Scripts
1 Comment

This T-SQL errors and reactions demo follows episode #002 with queries you can run. It shows what a CATCH block can read, how severity is stored, how to log a failure and keep going, and why THROW keeps the original error while RAISERROR replaces it.

Continue Reading
Mar6

Optimized Plan Forcing: Cutting Compile Time in SQL Server 2022

Pinal Dave
SQL Performance
Execution Plan, Query Store, SQL Performance, SQL Server 2022
No Comments

Check optimized plan forcing in SQL Server 2022 through scoped configuration and Query Store replay flags, then compare compile duration.

Continue Reading
Mar5

Why Staging Tables Earn Their Keep

Pinal Dave
SQL Tips and Tricks
Best Practices, Data Warehousing, Database, ETL
5 Comments

Use staging tables to preserve raw input, validate changes, separate extraction from publication, and make failed loads easier to diagnose and replay.

Continue Reading
Mar4

SQL SERVER – Technical Reference Guides for Designing Mission-Critical Solutions

Pinal Dave
SQL Tips and Tricks
SQL Server, SQL White Papers
1 Comment

While helping a friend, I found the Technical Reference Guides for Designing Mission-Critical Solutions, an interactive map of architecture guidance.

Continue Reading
Mar3

SQL SERVER – Various Leap Year Logics

Pinal Dave
SQL Tips and Tricks
SQL DateTime
3 Comments

Dividing by 4 is not enough to find a leap year. Readers shared various leap year logics in the comments, and here are the best of them.

Continue Reading
Mar2

Stopping a Trigger From Firing Itself With TRIGGER_NESTLEVEL

Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server
No Comments

A timestamp trigger that updates its own table can loop until SQL Server gives up. Here is the small guard that stops it, with a demo you can run.

Continue Reading
Mar1

Naming Conventions for Tables, Columns and Constraints

Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Coding Standards, SQL Constraint and Keys, SQL Server
No Comments

Use naming conventions for readable SQL Server tables, columns, keys and indexes, then find exceptions and plan safe renames with sp_rename.

Continue Reading
Previous 1 … 550 551 552 553 554 555 556 … 847 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

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