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
Dec19

Only Two VLFs: Cannot Shrink the Log File Any Further

Pinal Dave
SQL Tips and Tricks
Shrinking Database, SQL Error Messages, SQL Scripts, Transaction Log, VLF
No Comments

A log file with only two VLFs cannot shrink any further, and DBCC SHRINKFILE tells you so. The message says the number of logical log files cannot be fewer than 2. Here is the script that reproduces it and the DBCC LOGINFO output that explains it.

Continue Reading
Dec18

SQL SERVER – Information Message: Cannot shrink file in database to xxxx pages as it only contains yyyy pages.

Pinal Dave
SQL Tips and Tricks
Shrinking Database, SQL Error Messages, SQL Scripts, SQL Server
No Comments

A reader hardcoded 1 GB in my log shrink script and got: Cannot shrink file in database to xxxx pages as it only contains yyyy pages. I explain why it appears.

Continue Reading
Dec17

SQL SERVER – Error 21028 : Replication Components are not Installed on This Server

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Replication, SQL Server, SQL Server Management Studio
3 Comments

After I set up AlwaysOn for a client, configuring replication failed: Replication components are not installed on this server. Here is how to fix error 21028.

Continue Reading
Dec16

How to Create an Empty Table and Fool Optimizer to Believe It Contains Data? – Interview Question of the Week #204

Pinal Dave
SQL Interview Questions and Answers
SQL Performance, SQL Scripts, SQL Server, SQL Statistics, SQL Table Operation
2 Comments

How do you create an empty table and fool the optimizer into thinking it has data? Nobody asked me that in 20 years, but I use this trick in Health Checks.

Continue Reading
Dec15

SQL SERVER – FIX: Msg 15190 – There are still remote logins or linked logins for the server

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Scripts, SQL Server, SQL Server Security
1 Comment

Dropping a linked server with sp_dropserver failed with Msg 15190: There are still remote logins or linked logins for the server. Here is how to clear them.

Continue Reading
Dec14

Rebuild Log for Msg 1813: Could Not Open New Database

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Log, SQL Scripts, SQL Server, Transaction Log
1 Comment

Rebuild log is the way back from Msg 1813, Could not open new database, when the log file is corrupted. SQL Server expert Jeremy Roe sent me an updated script for newer versions. This post walks through his nine steps in order.

Continue Reading
Dec13

Set-ClusterParameter Error: ProbePort Does Not Exist on the Cluster Object

Pinal Dave
SQL Tips and Tricks
AlwaysOn, PowerShell, SQL Azure, SQL Error Messages, SQL Server Cluster
1 Comment

The Set-ClusterParameter error said Parameter ‘ProbePort’ does not exist on the cluster object. I hit it while setting up a probe port for an Always On listener in Azure. Two wrong values in my script were the cause, and fixing both let the script run.

Continue Reading
Previous 1 … 187 188 189 190 191 192 193 … 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