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
Jan4

SQL SERVER – Puzzle – Why Does UNION ALL Work but UNION Produces Error?

Pinal Dave
SQL Puzzle
SQL Scripts, SQL Server, SQL Union clause
25 Comments

A puzzle with TEXT columns: UNION ALL works fine, but UNION produces error. Can you tell why? The hint is in how UNION removes duplicates.

Continue Reading
Jan3

SQL SERVER – Slow Filestream Data Cleanup. What Should We Do?

Pinal Dave
SQL Tips and Tricks
Filestream, SQL Scripts, SQL Server
4 Comments

Slow Filestream Data Cleanup can follow deletion when files are still ineligible for garbage collection. One customer was running out of space.

Continue Reading
Jan2

SQL SERVER – Historical SSMS Vulnerability Assessment and Current Availability

Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Server, SQL Server Management Studio, SQL Server Security
3 Comments

SQL Vulnerability Assessment was available in older SSMS releases. My walkthrough used SSMS 17.4 with SQL Server 2012 or later.

Continue Reading
Jan1

Restart Azure SQL Database: What Works and What Doesn’t

Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL High Availability, SQL Lock, SQL Server
6 Comments

You can’t restart Azure SQL Database the way you restart SQL Server, because Microsoft runs the service. This post shows what to do instead: find and end the blocking session, scale the database, or trigger a failover. It tests the blocking query on a demo database and explains why a stack dump is not a restart.

Continue Reading
Dec31

How to List Queries With Memory Grant and Execution Plan? – Interview Question of the Week #154

Pinal Dave
SQL Interview Questions and Answers
SQL DMV, SQL Memory, SQL Scripts, SQL Server
2 Comments

A workshop customer suspected one of their queries used too much memory. Here is the script I gave them to list running queries with Memory Grant and plan.

Continue Reading
Dec30

SQL SERVER – Account Added Automatically in SQL Server Used by SharePoint

Pinal Dave
SQL Tips and Tricks
SharePoint, SQL Login, SQL Server, SQL Server Security
No Comments

A departed user’s account kept being added automatically to SharePoint database roles. How to catch who adds it, and from where, on SQL Server 2025.

Continue Reading
Dec29

SQL SERVER – xp_cmdshell and Net Use ERROR: The Local Device Name is Already in Use

Pinal Dave
SQL Tips and Tricks
Command Line, SQL Command, SQL Error Messages, SQL Scripts, SQL Server, SQL Stored Procedure
5 Comments

Mapping a share with net use through xp_cmdshell, I hit “The local device name is already in use”. Here is what causes this error and how to solve it.

Continue Reading
Previous 1 … 237 238 239 240 241 242 243 … 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