Question: What is Clean Buffer in DBCC DROPCLEANBUFFERS?
SQL SERVER – FIX: The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) Node.
Sometimes if the sequence is not followed correctly, we might see some weird errors. In this blog, we would learn how to fix always on an error while adding new replica “The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) node.”
SQL SERVER – How to Drop All the Hypothetical Indexes of Database?
Earlier I wrote a blog post SQL SERVER – Say No To Database Engine Tuning Advisor and I got an email from my existing client where I frequently engage for Comprehensive Database Performance Health Check. They wanted me to help them remove all the negative impact of the Database Engine Tuning Advisor (DTA). I was able to help them achieve this by removing the Hypothetical Indexes they had added using the DTA.
How to Extract Alphanumeric Only From A String? – Interview Question of the Week #214
Question: How to Extract Alphanumeric Only From A String?
SQL SERVER – Upgrade Error – Cannot Drop the Assembly ‘ISSERVER’, Because it Does not Exist or You Do Not Have Permission
A few days back, I published the blog on the same error message and one of the blog reader responded and ask how can I generate the script if I don’t have another SQL Server? In this blog, we would learn how to fix error Cannot drop the assembly ‘ISSERVER’, because it does not exist or you do not have permission.
SQL SERVER – Query Listing All the Indexes Key Column with Included Column
Today’s blog post is directly inspired by the conversation I had during my Comprehensive Database Performance Health Check. During the consulting engagement, we identified the customers had too many indexes on tables. The goal was to consolidate the indexes and to do the same, we realized that we needed a script which lists all the key columns and included columns of the indexes.
SQL SERVER – Windows Authentication or System Admin Account (SA)
I like to say that I am SQL Server Performance Tuning expert but often during the conversation, I end up discussing security as well. Recently I was asked about my preference for Windows Authentication or System Admin Account (SA) during one of the recent Comprehensive Database Performance Health Check.