Earlier this week, I wrote a few blog posts on SQL Server Deadlocks. Lots of people asked me if I could convert them into Interview Questions and Answers
SQL SERVER Challenge – Cumulative Total Calculation
Today we will see a very interesting SQL SERVER Challenge about Cumulative Total Calculation. During a recent Comprehensive Database Performance Health Check.
SQL SERVER – Count Occurrences of a Specific Value in a Column
Here is the exact question – How to Count Occurrences of a Specific Value in a Column? Well, honestly, the answer is very simple.
SQL Server Interview Questions and Answers: Updated 2021
I have just released an updated version of my most famous SQL Server Interview Questions and Answers: Updated 2021 after 10 years.
What is N in nvarchar? – Interview Question of the Week #301
Question: What is N in nvarchar?
Answer: n in nvarchar or nchar stands for world national. Let us learn today about datatypes.
How to Write Efficient Query? – Interview Question of the Week #300
Question: How to Write Efficient Query?
Answer: There is no right or wrong answer to this question. Let us learn about it today.
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.