Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Script to Find All Columns with a Specific Name in Database

January 22, 2020

Recently, one of the clients asked me if I have a Script to Find All Columns with a Specific Name in Database. Yes, of course, I do have it.

January 21, 2020

I have written a few blogs on issues about the failure of listener creation in the cluster. In this blog, we will explore listener creation failure.

January 20, 2020

After troubleshooting they found that when they run vssadmin list writers command from the command prompt, they are not seeing SqlServerWriter.

January 19, 2020

Question: How to Recompile Stored Procedure?
Answer: The answer to this question is here:

EXEC sp_recompile ‘NameofSP’

Let us read more about it.

January 18, 2020

In this blog, we would look into a special situation where ONLY SQL Server Agent is missing in SQL Server Configuration Manager.

January 17, 2020

I had a very interesting conversation with one of my clients about Cardinality Estimation for Temp Table vs Table Variable. Let us discuss it today.

January 16, 2020

This blog is from one that came from a DBA from one of my consulting engagements. Let us learn how to fix event id 7000 error.