SQL Server 2014 setup failed with an Install Error: standalone SQL Server on a WSFC cluster cannot have files on shared disk. Here is why and what to do.
How to Reduce High Virtual Log File (VLF) Count? – Interview Question of the Week #162
Found a high Virtual Log File (VLF) count in your database? Here are the steps I follow to bring the count down, starting with the log file details.
SQL SERVER – Installation Wizard Hang Forever – Please Wait on Feature Selection Page
Adding Analysis Services to SQL Server 2014, the Installation Wizard hung on “Please Wait” at feature selection, even after my lunch. Here is what fixed it.
SQL SERVER – Unable to Start SQL Server Agent. Error – Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed
SQL Server Agent would not start, and the log said Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed. Here are the logs I check and the fix I found.
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
This First Name From Full Name puzzle excludes CHARINDEX and SUBSTRING. It came from a customer query during a performance health check.
Sort in TempDB for Faster Index Rebuilds: When It Helps
To sort in tempdb during an index rebuild, add WITH (SORT_IN_TEMPDB = ON) to ALTER INDEX. This post tests the option and shows that the user database log stays the same size, because only the sort workspace moves. It also explains when the option helps, how much tempdb space it needs, and when to leave it off.