As they say – There are more ways than one to skin a cat. In this blog we will find another method to fix an error which you might see during SQL upgrades – Cannot drop the assembly ‘ISSERVER’, because it does not exist or you do not have permission.
What is Consolidation of Index? – Interview Question of the Week #212
Question: What is Consolidation of Index?
SQL SERVER – Enabling Older Legacy Cardinality Estimation
Yesterday, I had a very interesting situation, one of our Comprehensive Database Performance Health Check client immediately called me on Skype with his entire server going continuously stopping due to a very toxic poison wait type of Resource Semaphore. Though, we had a good idea how to fix the wait type the real issue was the server was not staying up long enough to put us a patch in the system. It was extremely frustrating for us and finally, we were able to deploy the patch Enabling Older Legacy Cardinality Estimation.
SQL SERVER – Find Out Current Language of the Session
After reading my post SQL SERVER – Puzzle – Playing with DateTime with Customer Data, one of my blog readers asked me “How to find out the current language setting of the session?”
Visual Studio – FIX: The ‘SqlStudio Profile Package’ Package Did Not Load Correctly
I am not sure what changes I made in one of my Virtual Machine, but I was running into an issue. In this blog, we would discuss how to fix error “The ‘SqlStudio Profile Package’ package did not load correctly” while launching Visual Studio.
SQL SERVER – Availability Group Seen in SSMS but missing in Cluster Manager. What’s Wrong?
One of my existing clients has sent me an interesting question. In this blog, I would share one interesting situation where my client has created an availability group and it was visible in SSMS, but no role was visible in failover cluster manager.
SQL SERVER – Say No To Database Engine Tuning Advisor
I have been using SQL Server for over 20 years and have been working on the focused area of SQL Server Performance Tuning for over 12 years. In recent time I have been very busy doing Comprehensive Database Performance Health Check, and the client, I enjoy working the most is the one who has used in the past Database Engine Tuning Advisor.
Feb 2019 Updates – Webcast, SQLBits, SQL Saturday and Performance Tuning of Your System
As February starts, just thought of dropping a note to let you know where you can find me in the upcoming months. Do scroll down all the way to read the change in offering in SQL Server Performance Tuning Workshop.
Does Parallel Threads Process Equal Rows? – Interview Question of the Week #211
Question: Does Parallel Threads Process Equal Rows?
SQL SERVER – Msg 2555: Cannot Move All Contents of File to Other Places to Complete the Emptyfile Operation
Once upon a time, I was trying to remove TempDB database additional files, but it was not working. In this blog I would explain the steps needed fix Msg 2555: Cannot move all contents of the file to other places to complete the emptyfile operation.