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
May15

PSPO Plan Variants: One Query, Several Plans in SQL Server

Pinal Dave
SQL Performance
Execution Plan, Parameter Sniffing, SQL DMV, SQL Server 2022
1 Comment

PSPO plan variants let SQL Server cache up to three plans for one parameterized query when the data is very skewed. This post builds a skewed table, shows two variants with different reads for three calls, compares the same calls with the feature off, and explains when PSPO does not apply.

Continue Reading
May4

Data Quality Asserts in T-SQL: Failing a Load When Rules Break

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

Write data quality asserts in T-SQL to reject invalid staging rows, preserve check results, and record each load attempt.

Continue Reading
Apr28

Chatty Applications: Finding Many Tiny Queries per Second

Pinal Dave
SQL Performance
SQL Counter, SQL Extended Events, SQL Monitoring, SQL Server, SQL Wait Stats
No Comments

Diagnose chatty applications with batch rates, cached executions, bounded session event counts, and measured round trips per user action.

Continue Reading
Apr26

Column-Level Permissions: Hiding One Column From Some Users

Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Server, SQL Server Security, SQL View
No Comments

Apply SQL Server column-level permissions, test DENY and SELECT behavior, inspect explicit grants, and compare views with data masking.

Continue Reading
Apr25

Cross-Database Ownership Chaining: Why It Is Off and What to Use

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

Understand cross-database ownership chaining, inspect its scope, and use signed procedures for narrow access between SQL Server databases.

Continue Reading
Mar8

Finding Oversized Data Files With Lots of Free Space

Pinal Dave
SQL Tips and Tricks
DBA, Disk, Shrinking Database, SQL Data Storage
No Comments

Identify oversized data files with FILEPROPERTY, separate internal free space from disk capacity, and review one-time shrink choices.

Continue Reading
Feb28

VLF Growth Rules: How Many Virtual Log Files One Growth Adds

Pinal Dave
SQL Tips and Tricks
SQL Server 2022, Transaction Log, VLF
No Comments

The VLF growth rules say how many virtual log files one log growth adds: one up to 64 MB, eight up to 1 GB, sixteen above. This post measures them on a demo database, shows a log with 68 VLFs from 1 MB steps, and repairs it by shrinking and growing once.

Continue Reading
Previous 1 … 42 43 44 45 46 47 48 … 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