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.