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
Jan29

Find All Queries with Implicit Conversion in SQL Server – Interview Question of the Week #107

Pinal Dave
SQL Interview Questions and Answers
SQL DMV, SQL Performance, SQL Scripts, SQL Server
6 Comments

Question: How do I find out how many queries have an Implicit Conversion in SQL Server? The source of this question is very interesting.

Continue Reading
Jan28

SQL SERVER – Script level upgrade for database master failed – Error: 4860, Severity: 16, State: 1 – Cannot bulk load. SqlTraceCollect.dtsx does not exist

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

SQL Server would not start after patching: script level upgrade for database master failed with error 4860, SqlTraceCollect.dtsx does not exist. The fix.

Continue Reading
Jan27

SQL SERVER – SQL Installation fails with error code 0x851A001A – Wait on the Database Engine recovery handle failed

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, Starting SQL
39 Comments

SQL Server setup failed with 0x851A001A: Wait on the Database Engine recovery handle failed. The ERRORLOG showed error 17120. Here is what caused it.

Continue Reading
Jan26

SQL SERVER – Using dm_db_stats_properties With InMemory OLTP Tables

Pinal Dave
SQL Tips and Tricks
In-Memory OLTP, SQL DMV, SQL Memory, SQL Server
No Comments

Does sys.dm_db_stats_properties show modified rows for InMemory OLTP tables? I tested it, and memory-optimized tables are now covered. Here is what I found.

Continue Reading
Jan25

SQL Server Performance Mistakes: Three Checks to Run Today

Pinal Dave
SQL Performance
SQL Index, SQL Performance, SQL Server, SQL Server Configuration
18 Comments

SQL Server performance mistakes hide in the settings, the files and the code. This post checks four server settings, shows poor file growth and its fix, and measures two code mistakes, a function on an indexed column and a data type mismatch, in logical reads.

Continue Reading
Jan24

Do You Need an Availability Group? Matching RPO and RTO to a Feature

Pinal Dave
SQL Tips and Tricks
AlwaysOn, DBA, Log Shipping, SQL Backup and Restore, SQL High Availability
4 Comments

Match RPO and RTO to backups, log shipping, failover clusters, or availability groups, then test the full service recovery path.

Continue Reading
Jan23

SQL SERVER – Script level upgrade for database ‘master’ failed – There is already an object named ‘DatabaseMailUserRole’ in the database

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

After patching, script level Upgrade for master failed: there is already an object named ‘DatabaseMailUserRole’. Here is what caused it and how to fix it.

Continue Reading
Previous 1 … 286 287 288 289 290 291 292 … 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