Recently I had a very interesting scenario with a client when they faced an error about already object named that exist in the database.
SQL SERVER – Stored Procedure Parameters and Single Quotes
Recently during SQL Health Check I had an interesting conversation with Sr. DBA about Stored Procedure Parameters and Single Quotes.
SQL SERVER – Fix Error 8632 – Internal Error: An expression Services Limit Has Been Reached
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.
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.
SQL SERVER – Fix: The operating system returned error 21(The device is not ready.)
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.)
SQL SERVER – Removing Additional Transactional Log Files
While working on Comprehensive Database Performance Health Check about additional transactional log files and today I got to follow up via email.