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.
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.
SQL SERVER – Nested Triggers – Trigger Calling Another Trigger Error
A reader asked what happens when one trigger calls another. Here is a simple example with two AFTER INSERT triggers that shows how nested triggers behave.
Clear Procedure Cache for One Database in SQL Server
To clear procedure cache for one database, run ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE_CACHE inside that database. This post tests it on two demo databases, shows that the other database keeps its plans, and shows how to remove a single plan by its plan handle. It also covers the cost and the lighter alternatives.