Here is one of the situations which I encountered with SQL Server 2014 on Windows Server 2012 R2. I wanted to add “Analysis Services” features to an existing installation. I came up with the feature selection screen on SQL setup and pressed next it hangs with “Please Wait”. I click on it and went for lunch, when I came back, it was still in the same state. Let us learn how to fix the issue related to Installation Wizard Hang Forever.
SQL SERVER – Unable to Start SQL Server Agent. Error – Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed
If someone tells me any situation, the first question which I always ask is “What is the error message?”. Now to get the right error message, it is important to look at the right log file. In this blog, we would learn about SQL Server Agent startup issue.
SQL SERVER – Unable to Start Jobs – Error: Enumerate Target Servers Failed for Job
They showed me below error when they were trying to run a job. Let us see how we can fix the error Enumerate Target Servers Failed for Job.
SQL SERVER – Puzzle – Get the First Name From Full Name Without CHARINDEX
Recently I have been engaged with a customer where they were having a performance issue. They have engaged me via my offering Comprehensive Database Performance Health Check. While doing that, they asked me to write a better way to write a query. While I have given some suggestions and asked them to check, this looks like a nice puzzle to ask. So here we go to see the puzzle – Get the First Name From Full Name Without CHARINDEX.
SQL SERVER – Improve Index Rebuild Performance by Enabling Sort In TempDB
During recent Comprehensive Database Performance Health Check, the customer put forward a compelling request. They wanted to improve their index rebuild performance as their index rebuilding process is taking forever to complete. When they asked me this, I exactly knew what we needed to do for this customer. We ended up fixing the issue of index rebuild by enabling sort in TempDB.
SQL SERVER- Unable to Failover AlwaysOn Availability Group to Disaster Recovery Site
One of my clients took my assistance to deploy Always On availability group. After few months, they added a Disaster Recovery node to windows cluster and availability group also. Later, they contacted me that they are not able to move availability group to DR node. They were getting an error like below in event viewer.
How to Get VLF Count and Size in SQL Server? – Interview Question of the Week #161
Question: How to Get VLF Count and Size Information in SQL Server?
SQL SERVER – Patch Rule Failure: Not Clustered or the Cluster Service is Up and Online
One of my clients contacted me for quick assistance. They were trying to install a Service pack for SQL Server 2016 instance, but it was failing with below error message about cluster service.
SQL SERVER – Maintenance Plan Error: Cannot Create a Task From XML For Task, Eue to Error 0x80070057. The Parameter is Incorrect. (OnPreExecute)
Once I encountered an error while creating new maintenance plans on my virtual machine.
SQL SERVER – Don’t Ignore Warning: Cluster Resource DLL Update Restart Check
This was one of the hard lessons learned, so I am sharing with blog readers. This is about an error in cluster resource DLL.
While applying the patch to SQL instance, I cluster, sometimes we get warning “Cluster Resource DLL Update Restart Check.” If we check Detail.txt file in setup logs, we will find below.