Recently during SQL Health Check I had an interesting conversation with Sr. DBA about Stored Procedure Parameters and Single Quotes.
When we tried to run a few of their stored procedure. How we can fix Error 8632 – Internal Error: An expression Services Limit Has Been Reached.
Question: How to Add Constraint With No Validation?
Answer: I got this question from one of my clients of who is an Oracle user.
Question: What Happens If the Clustered Index is Disabled?
Answer: If you disable the clustered index, you can’t retrieve data from the table.
The client was in very much panic as they were getting the following error – The operating system returned error 21(The device is not ready.)
While working on Comprehensive Database Performance Health Check about additional transactional log files and today I got to follow up via email.
Question: How to Solve Error When Transaction Log Gets Full?
Answer: This was a question I was asked in the recent Health Check.