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
Feb21

SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1 from table)

Pinal Dave
SQL Puzzle
Best Practices, SQL Scripts
43 Comments

Is IF EXISTS(Select null from table) faster than IF EXISTS(Select 1 from table)? A great comment thread by Divya, Brian and Marko answers it.

Continue Reading
Feb20

SQL SERVER – Recompile Stored Procedure at Run Time

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

Two ways to recompile a stored procedure at run time in SQL Server: add WITH RECOMPILE when you create it, or ask for a one-time recompile.

Continue Reading
Feb19

Mapping MySQL Data Types to SQL Server

Pinal Dave
SQL Tips and Tricks
MySQL, SQL Datatype, SQL DateTime, SQL Migration, SQL Server
1 Comment

Mapping MySQL data types requires checking signed ranges, text encoding, date limits, and application behavior before choosing SQL Server columns.

Continue Reading
Feb18

SQL SERVER – Plan Recompilation and Reduce Recompilation – Performance Tuning

Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Stored Procedure, SQL System Table
11 Comments

Plan recompilation hurts performance just like a first compile. Learn what causes it, from schema changes to SET options, and how to reduce recompilation.

Continue Reading
Feb17

Minimal Logging for Bulk Loads

Pinal Dave
SQL Tips and Tricks
CSV, SQL Backup and Restore, SQL Log, SQL Server, Transaction Log
2 Comments

Minimal logging for Bulk Loads depends on recovery model, table shape, and locking; learn the prerequisites, tradeoffs, and how to verify a load.

Continue Reading
Feb16

Stored Procedure Optimization Tips That Still Matter

Pinal Dave
SQL Performance
Best Practices, SQL Coding Standards, SQL Stored Procedure
181 Comments

Stored Procedure Optimization comes down to a short list of habits you can test on your own server. This post builds one badly written procedure and one good one on a small orders table, then measures the difference in logical reads. It also covers parameter sniffing, the sp_ prefix, short transactions and error handling.

Continue Reading
Feb15

SQL SERVER – Difference Between Update Lock and Exclusive Lock

Pinal Dave
SQL Interview Questions and Answers
SQL Lock
15 Comments

What is the difference between Update Lock and Exclusive Lock? An Update Lock can sit on a row that has a Shared Lock, then turns Exclusive when it writes.

Continue Reading
Previous 1 … 665 666 667 668 669 670 671 … 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