June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL Server Performance Tuning Expert frontimage1

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

SQL Server Performance Tuning Expert frontimage2

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

For SQL Server Emergency Help, you can reach out to me at pinal@sqlauthority.com with words URGENT in the email subject line for other services mention “Comprehensive Database Performance Health Check“.

SQL SERVER – 2017 – Script to Clear Procedure Cache at Database Level

Pinal Dave
SQL Tips and Tricks
SQL Cache, SQL Scripts, SQL Server, SQL Server 2017
2 Comments

When my customer ask they want to clear the cache of the database, I always so NO. It is not necessary. However, I have come to the realization that customers are always right and sometimes even though I say no, they still want to do it. One way or another way, they will eventually do what they want. Let us learn about Script to Clear Procedure Cache at Database Level.

Read More

SQL SERVER – Identity Jumping 1000 – IDENTITY_CACHE

Pinal Dave
SQL Performance
SQL Identity, SQL Scripts, SQL Server, SQL Server 2017
21 Comments

SQL Server 2017 has a wonderful feature which fixes a very old issue which DBA and developers have been struggling for a while. It would be impossible to find DBA or Developer who has not faced an issue when their identity column value has jumped or incremented by 1000. It is a very common issue and today we will see the solution of this issue with the help of IDENTITY_CACHE introduced in the latest version of SQL Server. 

Read More

SQL SERVER – How to Kill All the Processes for Any Database?

Pinal Dave
SQL Tips and Tricks
SQL Cursor, SQL Scripts, SQL Server
No Comments

Recently during Comprehensive Database Performance Health Check, to test our unique fix, we had to run a stress test on my customer’s development environment. Once we were done testing our script, we did not need our stress test queries to run on our server. Even though we stopped to run the batch file with stress test queries, there were few long-running queries kept on running on the server. This brought us to a very interesting point where we had to kill all the processes for one particular database.

Read More

SQL Authority News – Join me at SQLBits 2018 – 36 Scripts: Performance Tricks Jedi Master Wants You to Know

Pinal Dave
SQLAuthority News
SQL Performance, SQL Server, SQLAuthority Author Visit, SQLBits
No Comments

Many of you have previously attended my SQL Server Performance Tuning Practical Workshop. If you have attended this session, you probably know that my workshops are very quick paced and with simple tips which one can easily put in the practice. These workshops are an online and very effective way to learn while you are in the comfort of your office or home. Based on this workshop, I have to build another in-person workshop which is called “36 Scripts: Performance Tricks Jedi Master Wants You to Know”.

Read More

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 14 SQL Server database books and 92 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 an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@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.