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
Sep19

SQL SERVER – Remove Duplicate Rows Using UNION Operator

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Union clause
16 Comments

The UNION operator removes duplicates from a query result without deleting source rows. I use a small example to show that distinction.

Continue Reading
Sep18

Log Reuse Wait Reason AVAILABILITY_REPLICA: What It Means and How to Fix It

Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Replication, SQL Scripts, SQL Server, Transaction Log
6 Comments

A customer’s database always showed AVAILABILITY_REPLICA as the log reuse wait reason in sys.databases. Here is what it means and three causes to check: a slow network, a long running transaction and a resource constraint.

Continue Reading
Sep17

Find the Query Growing TempDB in SQL Server

Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL TempDB
2 Comments

To find the query growing TempDB, read the space each session has allocated and join it to its statement. This post separates temporary tables from spills, watches both live in a second window and shows the totals after a query ends. It ends with ways to fix a spill.

Continue Reading
Sep16

Where is the Default Settings for Backup Compression? – Interview Question of the Week #191

Pinal Dave
SQL Interview Questions and Answers
Compression, SQL Backup and Restore, SQL Scripts, SQL Server, SQL Server Configuration
2 Comments

Where are the default settings for backup compression? The Back Up dialog shows three options. Here is where the server default lives and how to set it.

Continue Reading
Sep15

Estimated Completion Time for Backup, Restore and DBCC

Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL DMV, SQL Scripts, SQL Server DBCC
3 Comments

The estimated completion time of a backup, restore or DBCC command is one query away. This post builds a monitor query on sys.dm_exec_requests and watches a backup, a restore and a DBCC check in a second window. It also covers STATS and the DBCC step name.

Continue Reading
Sep14

Max Degree of Parallelism for Microsoft Dynamics CRM

Pinal Dave
SQL Performance
MAXDOP, Parallel, SQL Scripts, SQL Server Configuration
5 Comments

Max degree of parallelism controls how many cores one query can use, and the vendor guidance for Microsoft Dynamics CRM has been 1. This post measures what parallel plans cost on a heavy and a small query. It shows a database scoped limit and the instance wide statements.

Continue Reading
Sep13

SQL SERVER – Microsoft Azure – Unable to Find Higher Tier Series Virtual Machine to Upgrade

Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Azure, SQL Error Messages, SQL High Availability, SQL Server, Virtualization
No Comments

My client wanted to upsize an Azure VM running Always On from D-Series to a higher tier G-Series size, but it was missing from the list. Here is what I suggested.

Continue Reading
Previous 1 … 200 201 202 203 204 205 206 … 846 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