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
Mar18

Masked Values: What Dynamic Data Masking Does Not Hide

Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Encryption, SQL Server Security
No Comments

A masked column shows zeros, but a user with SELECT can still filter, sort and guess the real values. Here is the proof and the fix.

Continue Reading
Mar17

Does Column Order in CREATE TABLE Change How Rows Are Stored?

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

Someone wants to reorder columns to shrink rows. I measured it on SQL Server 2025, and the answer is mostly no, with one small exception worth knowing.

Continue Reading
Mar16

Reading Pending I/O Requests During a Storage Slowdown

Pinal Dave
SQL Performance
Disk, SQL DMV, SQL Performance, SQL Wait Stats
No Comments

Sample pending I/O requests during PAGEIOLATCH or WRITELOG stalls, map each request to a file, and share timed evidence.

Continue Reading
Mar15

Finding Which Database Uses the Most CPU on a Shared Instance

Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Performance, SQL Server
1 Comment

Find which database uses the most CPU from cached query stats and plan attributes, then use Query Store for restart-safe history.

Continue Reading
Mar14

Pluralsight Author Summit 2013: A Truly Amazing Experience

Pinal Dave
SQLAuthority News
Conferences, Pluralsight, Professional Development, SQLAuthority Author Visit
1 Comment

The Pluralsight Author Summit in Salt Lake City was three days of learning and networking with authors who all love to share knowledge. Here is my recap of the sessions, the dinners, the management talks and the last day at a ski resort, with the photographs.

Continue Reading
Mar13

SELECT a Single Row in SQL Server: SQL in Sixty Seconds #046

Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Server Management Studio, SQL Shortcut, SQL Top
3 Comments

To SELECT a single row for a quick look at a table, set up an SSMS query shortcut that runs SELECT TOP 1. The tests here show which row comes back, how an index or a heap changes it, what it costs on a 200,000 row table and when to add ORDER BY.

Continue Reading
Mar12

SQL SERVER – Avoid Using Function in WHERE Clause – Scan to Seek

Pinal Dave
SQL Performance
SQL Function, SQL Index
18 Comments

Does a function in WHERE clause really hurt performance? Using AdventureWorks and STATISTICS IO, I show what happens and how to turn a scan into a seek.

Continue Reading
Previous 1 … 496 497 498 499 500 501 502 … 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