Error 2714 reported that MyFirstTable already existed, but the client found no such table. A query on sys.objects showed a primary key constraint with that name on another table. Creating the table under another name, or renaming the key, fixes it.
Unquoted Procedure Parameters: Are Single Quotes Optional?
Unquoted procedure parameters work in SQL Server when the value is one plain word. This post builds a small procedure and tests which values fail without single quotes. It also shows how NULL, DEFAULT and numbers change the value.
Error 8632: Internal Error, Expression Services Limit Reached
Error 8632 says an expression services limit has been reached. It appeared in a few stored procedures after a SQL Server upgrade. Recreating the procedures, and the nested ones, fixed it without a restart.
How to Add Constraint With No Validation? – Interview Question of the Week #299
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.