Question: How to Add Constraint With No Validation?
Answer: I got this question from one of my clients of who is an Oracle user.
What Happens If the Clustered Index is Disabled? – Interview Question of the Week #291
Question: What Happens If the Clustered Index is Disabled?
Answer: If you disable the clustered index, you can’t retrieve data from the table.
Device Is Not Ready: Fix Operating System Error 21
Device Is Not Ready is the Windows text behind operating system error 21, which SQL Server reports inside error 823. This post explains what the message means, lists the common causes, and gives read-only checks to run before any restart. It ends with the DBCC CHECKDB step that proves the database is healthy.
Remove Extra Log File in SQL Server: Fix Error 5042
To remove extra log file members, SQL Server needs the files to hold no active log. When one does, ALTER DATABASE REMOVE FILE fails with Msg 5042. This post builds a database with two log files, reproduces the error, shows which VLFs keep the file busy and frees it with log backups. It also explains why the file stays offline until the next log backup.
How to Solve Error When Transaction Log Gets Full? – Interview Question of the Week #272
Question: How to Solve Error When Transaction Log Gets Full?
Answer: This was a question I was asked in the recent Health Check.
SQL SERVER – Fix: Configuration Manager- Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable
Let us learn how to solve Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable.
SQL SERVER – Upgrade Failure – There are No More Endpoints Available From the Endpoint Mapper
When my client was trying to patch the other node, it failed with an error – There are No More Endpoints Available From The Endpoint Mapper