Doing create catalog in SSMS failed with Error 911: database SSISDB does not exist. Here is how SQL Server Profiler showed me the real cause.
SQL SERVER Data Tools – SSDT for Visual Studio 2017 Installation Error 0x80070002: Error 0x80070002: Failed to Acquire Payload
SSDT for Visual Studio 2017 would not install on my new demo machine. Here is the Installation Error 0x80070002 I found in the setup log in the TEMP folder.
How Does TOP WITH TIES Work in SQL Server? – Interview Question of the Week #159
Question: How Does TOP WITH TIES Work in SQL Server?
Answer: This is an ancient question I just encountered in the recent Comprehensive Database Performance Health Check.
SQL SERVER – Unable to Start SQL Service Error: 17172 – SNIInitialize() Failed with Error 0x2
While building a lab cluster, I could not start SQL Service: Error 17172, SNIInitialize() failed with error 0x2. Here is what the ERRORLOG showed and the fix.
SQL SERVER – SQL Service Not Starting in Cluster- The System Cannot Find the File Specified
A clustered instance would not fail over because the SQL Service on Node2 did not start: the system cannot find the file specified. Here is what we found.
SQL SERVER – FIX: Msg 3009 – Could Not Insert a Backup or Restore History Detail Record in the MSDB Database
A backup finished but raised Msg 3009: could not insert a backup or restore history detail record in msdb. Here is why, with steps to reproduce it.
SQL SERVER – Incorrect Error: Unable to Add Filegroup – A Severe Error Occurred on the Current Command
A client with a huge partitioned database could not add filegroup and got Msg 0, a severe error. Here is how we found the real, much deeper issue.