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
Jun17

Autogrowth Settings: Why 1 MB and 10 Percent Still Hurt

Pinal Dave
SQL Tips and Tricks
DBA, SQL Data Storage, SQL Server Configuration, Transaction Log
No Comments

Inspect autogrowth settings across database files, review retained growth events and VLFs, and choose tested fixed-size increments.

Continue Reading
Jun16

SQL SERVER – SPARSE Property Doesn’t Carry Forward Using SELECT INTO

Pinal Dave
SQL Tips and Tricks
2 Comments

SELECT INTO copies most column attributes to a new table, but not all. Here is proof that the SPARSE property does not carry forward using SELECT INTO.

Continue Reading
Jun15

SQL SERVER – Startup Problem – FIX – Error 5118, Severity 16, State 1

Pinal Dave
SQL Tips and Tricks
MySQL, SQL Error Messages
7 Comments

The SQL Server service would not start for a DBA fresh out of college. The cause was Error 5118, and here is how to read it and fix it.

Continue Reading
Jun14

Interview Question of the Week #024 – What is the Best Recovery Model?

Pinal Dave
SQL Interview Questions and Answers
SQL Backup and Restore
No Comments

Choose the best recovery model from your restore requirements, understand bulk-logged limits, and verify the backup chain and log reuse.

Continue Reading
Jun13

SQL SERVER – Login failed for User ‘NT AUTHORITY\ANONYMOUS LOGON’ – ERRORLOG

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Log, SQL Server, SQL Server Security
16 Comments

A reader’s event log and ERRORLOG filled up with Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Here is why it happens and how SPN errors are involved.

Continue Reading
Jun12

SQL SERVER – How Many Line of Code Do You Have in Database?

Pinal Dave
SQL Tips and Tricks
SQL Saturday, SQL Scripts, SQL Server, SQLAuthority Author Visit
18 Comments

After the first SQLSaturday in Sri Lanka, here is a question worth a script: how many lines of code do you have in your database? Here is a way to count them.

Continue Reading
Jun11

SQL SERVER – The Basics of the Execute Process Task – Notes from the Field #084

Pinal Dave
SQL Tips and Tricks
Notes from the Field, SSIS
10 Comments

Andy Leonard explains the basics of the SSIS Execute Process Task, used to start a custom application or run an operating system command from a package.

Continue Reading
Previous 1 … 372 373 374 375 376 377 378 … 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