Question: How to find the longest running query in SQL Server with Execution Plan?
How to Find Size of All the Indexes on the Database – Interview Question of the Week #097
Question: How to Find Size of All the Indexes on the Database?
How Many Foreign Key Can You Have on A Single Table? – Interview Question of the Week #096
Question: How Many Foreign Key Can You Have on A Single Table?
I was asked above question in my recent SQLPASS presentations. I quickly answered that it is 253. However, after I returned home when I searched a bit more, I realized that my answer is not complete, hence this blog post.
Performance Comparison EXCEPT vs NOT IN – Interview Question of the Week #095
During SQLPass summit, I was asked following question by one of the attendees. The question was about Performance Comparison of Except vs NOT IN. Let us quickly discuss this question.
Question: Which of the operator is better for query performance – EXCEPT or NOT IN?
Fastest Way to Display Code of Any Stored Procedure – Interview Question of the Week #094
A very common question I often see users not sure about the answer. This is indeed a tricky question, but a very simple one. If I am the interviewer, I may ask this question to the user, but if they do not know the answer of this question, I would not give any negative remarks to interviewee. I think it is even old school to even ask these kind of questions. It has been long since I have stopped asking this question, once in a while, I still see this question being asked by my fellow colleagues. Well, let us revisit the age old question again about the fastest way to display code of any stored procedure.
When was Domain Account Password Changed in SQL Server? – Interview Question of the Week #093
If you are a DBA for quite some time, then at least once you must have encountered below error about Domain Account Password.
Error 1069: The service did not start due to a logon failure. I have already written a blog about this long ago.
What is a Backup Timeline for Restore Process? – Interview Question of the Week #092
Question: What is a Backup Timeline for Restore Process?
Answer: One of the most popular interview question about Backup and Restore Database process.