SQL Server Performance Tuning is not as difficult as most of the people think. Actually, SQL Server performance tuning is very easy and simple, if you exactly know what to do and when to do. Well, that is what is the theme of the free webinar which I have done for 24 Hours of PASS.
SQL SERVER – Transfer Logins Error: Msg 15419: Supplied Parameter sid Should be Binary(16) – sp_help_revlogin
While I was writing my earlier blog, I came across another interesting issue with sp_help_revlogin script. In this blog we would learn about the cause of Msg 15419, “Supplied parameter sid should be binary(16)” while transferring the login using sp_help_revlogin and see how to fix it.
SQL SERVER – Unable to Install Reporting Service Add-In for SharePoint – System.ArgumentException
There are so many components in SQL Server and sometimes there is an error in installing components which I have not used at all. One such component is SSRS with SharePoint. To use this, we need to install Reporting Service Add-In for SharePoint. In this blog, we would see how to fix error System.ArgumentException which was encountered during the installation of Reporting Service Add-In for SharePoint.
SQL SERVER – Transfer Logins Error: Msg 15021: Invalid Value Given for Parameter Password
One of my existing clients contacted me for assistance in fixing an error. Sometimes, if the error is easy and it doesn’t take more than 10-15 minute, I give them the benefit of being my existing customer and I give free consulting (not always though). They informed me that they need moving SQL logins (username and password) from one server to another. To achieve that they were using sp_help_revlogin. Here are the steps:
Practical Real World Performance Tuning – Before the Class Announced
I recently completed delivering Practical Real World Performance Tuning for Brent Ozar Unlimited and it was great 3 days of delivery. Here are my thoughts about my entire experience and how everything worked out. Let us go on the journey to Behind the Scenes for Teaching Online Class.
How Much Work Each Processor (CPU) is Doing in SQL Server? – Interview Question of the Week #178
Question: How Much Work Each Processor (CPU) is Doing in SQL Server?
Answer: To be honest, I have not seen this question asked in any of the interview questions so far. Actually, this question was asked by one of my clients during Comprehensive Database Performance Health Check. Every time whenever he logs into his system, he finds his CPU running very very high even though he had over 56 active processors. What he really wanted to know what exactly is going on behind the scene of his processors. He really wanted to figure out, how busy his servers are and how much work is pending per Processor (CPU)?
SQL SERVER – Adding Values WITH OVER and PARTITION BY
Once in a while, I get questions where users have indeed explained the question well enough that I can easily understand their question. If I understand question quickly, I am always able to answer it efficiently as well. In this blog post, we will see one such question which I answered with keywords WITH OVER and PARTITION BY.
SQL SERVER – Optimal Value Max Worker Threads
During Comprehensive Database Performance Health Check, one of the DBas asked what is the most optimal value for Max Worker Threads. The question was indeed asked when my customer looked at the value of Max Worker Threads in the Processor sections of the Server Property, they were really worried. The default value of the Max Worker Threads is always set to zero.
SQL SERVER – How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)?
Question: How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)?
SQL SERVER – Performance Comparison IN vs OR
Some questions never get old and some question and I believe we will be discussing them for many more years in the future. Just other days, I received this question during my SQL Server Performance Tuning Practical Workshop. The question was about Performance Comparison IN vs OR. Though personally, I have answered this question quite a many times before, let us answer it once again, it never hurts to repeat the truth multiple times.