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
Sep22

SQL SERVER – Set AUTO_CLOSE Database Option to OFF for Better Performance

Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Management Studio
13 Comments

How I helped a customer get better performance by setting the AUTO_CLOSE Database Option to OFF, and why this setting hurts busy databases.

Continue Reading
Sep21

SET NOCOUNT ON in SQL Server: How to Hide Rows Affected Messages

Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server Management Studio, SQL Stored Procedure
4 Comments

SET NOCOUNT ON stops SQL Server from sending a rows affected message after every statement. This post tests what it changes and what it doesn’t: @@ROWCOUNT, scope inside a procedure, timing and the text that sp_updatestats prints. It also covers client programs that depend on the count.

Continue Reading
Sep20

Change in Date Format: Why LEFT Turns GETDATE Into Text

Pinal Dave
SQL Puzzle
SQL DateTime, SQL Function, SQL Scripts, SQL Server
168 Comments

A change in date format shows up when you apply LEFT to GETDATE: the date goes from year first to month name first. This puzzle explains the implicit conversion behind it, how language settings change the text, and how to get the date you want on purpose.

Continue Reading
Sep19

SQL SERVER – How to INSERT or SELECT Copyright Special Characters in SSMS?

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

A reader asked how to insert or select copyright special characters in SSMS. The answer is ALT codes, like ALT + 0169 for the copyright sign, plus two more.

Continue Reading
Sep18

How to Find Missing SQL Server Configuration Manager? – Interview Question of the Week #089

Pinal Dave
SQL Interview Questions and Answers
SQL Server, SQL Server Management Studio, Starting SQL
13 Comments

Question: I just installed the latest version of SQL Server and now I am not able to find SQL Server Configuration Manager. What should I do?

Continue Reading
Sep17

Resource Bottlenecks in SQL Server: A Wait Stats Script That Groups Them

Pinal Dave
SQL Performance
SQL DMV, SQL Scripts, SQL Server, SQL Wait Stats
7 Comments

Resource bottlenecks hide in the wait statistics, under a pile of idle waits and totals since startup. This post builds a script that removes the idle waits, measures an interval and groups the rest by resource. It also explains how to read each group and the signal wait.

Continue Reading
Sep16

SQL SERVER – Case of Different Default Collation on Two Servers

Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Server
5 Comments

My client saw a different default collation on two servers installed with SQL Server 2012. Here is what decides the default collation during setup.

Continue Reading
Previous 1 … 305 306 307 308 309 310 311 … 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