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
Sep28

SQL SERVER – What Are Ghost Records and How to Clean Them Up?

Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server
6 Comments

Ghost Records are logically deleted index records waiting for physical cleanup. I investigate their context before recommending an intervention.

Continue Reading
Sep27

Querying a Histogram With sys.dm_db_stats_histogram Instead of DBCC

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

Query sys.dm_db_stats_histogram to inspect statistics steps, compare stored estimates with data, and identify values beyond the last step.

Continue Reading
Sep26

SQL SERVER – Select Unique Data From a Column Exist in Two Different Table

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

A reader wanted to Select Unique Data from a column in two tables, keeping only values found in just one of them. Here is the query that does it.

Continue Reading
Sep25

SQL SERVER – Simple Explanation of AT TIME ZONE Feature

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

The AT TIME ZONE feature arrived in SQL Server 2016. Here is a simple two-step example that converts US East Coast time to West Coast time.

Continue Reading
Sep24

How to Kill User Sessions (SPID) in SQL Server? – Interview Question of the Week #141

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

How do you Kill User Sessions (SPID) in SQL Server? First ask why you want to, since killing busy sessions rarely helps. Then here is the script.

Continue Reading
Sep23

SQL SERVER – The Operating System Returned the Error 21(The Device is Not Ready.) While Attempting ‘GetDiskFreeSpace’ on ‘A:\’

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server
No Comments

While testing SQL Server 2017, I found Error 21 (the device is not ready) in the ERRORLOG for GetDiskFreeSpace on drive A. Here is why it shows up.

Continue Reading
Sep22

SQL SERVER – New DMV in SQL Server 2017 – sys.dm_os_enumerate_fixed_drives. A Replacement of xp_fixeddrives

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server 2017, SQL Stored Procedure
3 Comments

SQL Server 2017 adds sys.dm_os_enumerate_fixed_drives, a new DMV that shows free space on each drive and replaces xp_fixeddrives. Here is the query I use.

Continue Reading
Previous 1 … 251 252 253 254 255 256 257 … 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