A client used AlwaysOn automatic seeding for a huge database, but it stayed in Restoring state on the secondary. Here is the reason we found.
Which is Better for Performance – SELECT or SET? – Interview Question of the Week #166
Which is Better for Performance, SELECT or SET? In a loop, one SELECT that assigns several variables beats separate SET statements. Here is why.
QL SERVER – Unable to Create Listener: Msg 41009 – The Windows Server Failover Clustering (WSFC) Resource Control API Returned Error Code 5057
Creating an AG listener failed with Msg 41009: the Windows Server Failover Clustering (WSFC) resource control API returned error 5057. Here is the fix.
High CPU Consumption in SQL Server: Where to Look First
High CPU consumption in SQL Server comes from a handful of causes, and a short checklist finds them in order. This post reads the scheduler queue, ranks cached queries by CPU, and checks the Common Criteria Compliance setting that caused a known CPU problem after upgrades. It ends with the update that fixed that case and the questions to ask before you add cores.
SQL SERVER – The Report Server Cannot Open a Connection to the Report Server Database. (rsReportServerDatabaseLogonFailed)
A report viewer failed with rsReportServerDatabaseLogonFailed: the report server cannot open a connection to the report server database. Here is the fix.
Error 14001 in SQL Server: Side-by-Side Configuration Is Not Correct
Error 14001 reports a side-by-side configuration failure before a program starts, and the Application log event names the missing assembly. This post reads that event, matches the assembly to its architecture and checks WinSxS and the installed runtimes with tested PowerShell commands.
SQL SERVER – FIX: Msg 3231 – The Media Loaded on “Backup” is Formatted to Support 1 Media Families, but 2 Media Families are Expected According to the Backup Device Specification
Preparing a demo, I hit Msg 3231: media formatted for 1 media family, but 2 Media Families are expected. Here is what causes it and how to fix it.