Launching Visual Studio on my VM failed with: The ‘SqlStudio Profile Package’ package did not load correctly. I gathered a list of fixes that can solve it.
SQL SERVER – Availability Group Seen in SSMS but missing in Cluster Manager. What’s Wrong?
A client’s availability group showed in SSMS, but no role appeared in Failover Cluster Manager. Here is the sequence of steps that causes this and what to do.
SQL SERVER – Say No To Database Engine Tuning Advisor
I review Database Engine Tuning Advisor recommendations against the workload before applying them. That was the point behind my original opinion.
WRITELOG Waits: Finding What Slows Transaction Log Writes
Diagnose WRITELOG waits with log-file latency, commit patterns, and measured choices for batching, storage, and durability.
Does Parallel Threads Process Equal Rows? – Interview Question of the Week #211
Do parallel threads process equal rows? Usually no, and a simple AdventureWorks query with its actual execution plan proves it in a few seconds.
Msg 2555: Cannot Empty a TempDB File With EMPTYFILE
Msg 2555 stopped a client from emptying and removing extra TempDB files with DBCC SHRINKFILE and EMPTYFILE. The messages window showed a work table page that could not be moved. Cache-clearing commands and a restart did not help, but the -f startup parameter did.
SQL SERVER – Patch Failure – Unable to Retrieve the Cluster Service
Patching SQL Server 2008 R2 on a Windows Server 2012 cluster failed: unable to retrieve the Cluster Service. Here is what Detail.txt showed and the fix.