Question: How to downgrade from SQL Server 2014 to SQL Server 2012?
Answer: Not possible.
Question: How to downgrade from SQL Server 2014 to SQL Server 2012?
Answer: Not possible.
Question: How to find the longest running query in SQL Server with Execution Plan?
Question: How to Find Size of All the Indexes on the Database?
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.
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?
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.
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.