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
Jan6

Most Used Database Files – SQL in Sixty Seconds #190

Pinal Dave
SQL Video
SQL Data Storage, SQL in Sixty Seconds, SQL Performance
No Comments

If a client has many databases, this script finds the most used database files. Here is my SQL in Sixty Seconds video on it.

Continue Reading
Jan4

Reads and Writes per File: Rank Files by Bytes Moved

Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL DMV, SQL Performance
No Comments

Reads and writes per file show which data or log file SQL Server uses the most. This post ranks the files of a demo database by bytes moved with sys.dm_io_virtual_file_stats and explains what the tally can and cannot tell you.

Continue Reading
Dec29

Optimize DATE in WHERE Clause – SQL in Sixty Seconds #189

Pinal Dave
SQL Video
SQL DateTime, SQL in Sixty Seconds, SQL Performance
No Comments

During Comprehensive Database Performance Health Check, I often get questions about how to Optimize DATE in the WHERE Clause.

Continue Reading
Dec27

Splitting OR Conditions Into UNION ALL for Index Seeks

Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Server, SQL Union clause
No Comments

Test splitting OR conditions into disjoint UNION ALL branches, preserve NULL behavior and row identity, and compare actual index access.

Continue Reading
Dec23

Recovering One Dropped Table From a Full Backup

Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Table Operation
No Comments

Recover one dropped table through a separate restored database, choose the recovery point, copy its data, and rebuild the table rules.

Continue Reading
Dec16

Data Compression for Performance – SQL in Sixty Seconds #188

Pinal Dave
SQL Video
Compression, SQL in Sixty Seconds, SQL Performance, SQL Server
No Comments

Earlier I wrote a blog post about how Data Compression for Performance can help improve the efficiency of SQL Server.

Continue Reading
Dec15

Estimate Compression Savings for Every Table in a Database

Pinal Dave
SQL Tips and Tricks
Compression, SQL Scripts, SQL Stored Procedure
No Comments

To estimate compression savings for every table, loop over the database and call sp_estimate_data_compression_savings with ROW and PAGE. This post ranks tables by space saved and checks one estimate against a real rebuild.

Continue Reading
Previous 1 … 49 50 51 52 53 54 55 … 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