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
Nov28

AutoRecover Settings in SSMS: Protect Your Unsaved Queries

Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Server Management Studio, SQL Utility
7 Comments

The AutoRecover settings in SSMS decide how often unsaved work is copied to disk and how long the copies are kept. This post shows where to find the two options, what they can and cannot protect, how to test them once, and which habit still matters more than any setting.

Continue Reading
Nov27

Distributed Availability Groups: Linking Two Sites Without One Big Cluster

Pinal Dave
SQL Tips and Tricks
AlwaysOn, DBA, SQL High Availability, SQL Server Cluster
No Comments

Understand distributed availability groups, connect two existing groups across sites, inspect health, and plan recovery without one cluster.

Continue Reading
Nov26

SAMPLED vs DETAILED: Running index_physical_stats Safely

Pinal Dave
SQL Performance
SQL Index, SQL Performance, SQL Server
No Comments

A misspelled table name quietly turns into a scan of everything. Here is the guard, and a fair comparison of the three scan modes on one small index.

Continue Reading
Nov25

SQL SERVER – Find Weekend and Weekdays from Datetime in SQL Server 2012

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server, SQL Server 2012
18 Comments

Is today a weekend or a weekday? A question from the very first SQL Bangalore User Group meeting, answered with the CHOOSE function in SQL Server 2012.

Continue Reading
Nov24

Cursor Options That Matter: LOCAL, FAST_FORWARD and STATIC

Pinal Dave
SQL Tips and Tricks
SQL Cursor, SQL Server, SQL Stored Procedure, SQL TempDB
1 Comment

Test SQL Server cursor options, including LOCAL FAST_FORWARD and STATIC, on one loop while measuring time and tempdb cost.

Continue Reading
Nov23

sys.dm_os_waiting_tasks: Who Is Waiting Right Now and Why

Pinal Dave
SQL Performance
SQL DMV, SQL Lock, SQL Monitoring, SQL Wait Stats
No Comments

sys.dm_os_waiting_tasks shows every task that waits right now, what it waits for and who is in the way. This post builds a three-session blocking chain on SQL Server 2025, reads the view, finds the head of the chain and names the locked table.

Continue Reading
Nov22

SQL SERVER – Removing Leading Zeros From Column in Table – Part 2

Pinal Dave
SQL Tips and Tricks
SQL Function
9 Comments

Part 2 on removing leading zeros from column values: readers improved my sample with all-zero values and shared better methods, collected here.

Continue Reading
Previous 1 … 512 513 514 515 516 517 518 … 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