A client ran the shrink command again and again, but TempDB would not get any smaller. Here is how to Shrink TempDB without a SQL Server restart.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – The Automatically Saved Settings file NewSettings.vssettings Cannot be Found
After cleaning up some data from my user profile, when I launched SQL Server Management Studio 17.4, I got an error. related to automatically saved settings.
SQL SERVER – Puzzle – How Does Table Qualifier Work in INSERT Statement?
You can use a table alias in SELECT just fine, but how does a Table Qualifier work in the column list of an INSERT statement? Try this short puzzle.
SQL SERVER – Why SQL Server Service is Stuck in Starting / Change Pending State?
A reader’s SQL Server service was stuck in Starting / Change Pending in Configuration Manager. Here is what the ERRORLOG showed in this variation and the fix.
SQL SERVER – How to Execute the Query Without Using Management Studio?
A client’s security team removed SQL Server Management Studio from the server. Here are simple ways for beginners to run a query without it.
SQL SERVER – Empty Startup Parameter in SQL Cluster on One Node
Many problems lead to the same symptom. Here is another reason for an empty startup parameter in SQL Cluster, when it was not a registry permission issue.
SQL SERVER – Install Error: Standalone SQL Server on WFC Cluster Cannot Have Files on Shared Disk Locations
SQL Server 2014 setup failed with an Install Error: standalone SQL Server on a WSFC cluster cannot have files on shared disk. Here is why and what to do.
SQL Server slow? Let's fix it together in about four hours.
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.

