SQL Interview Questions and Answers Archives - Page 40 of 67

Interview Question of the Week #039 – What is Included Column Index in SQL Server 2005 and Onwards?

October 4, 2015

SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks

You may find it interesting that not many people still know what is Included Index in SQL Server. I have seen it personally around me and also have seen at Question: What is Included Column Index? Answer: In SQL Server 2005, the functionality of non-clustered indexes is extended by adding non-key…

Interview Question of the Week #038 – What is Left Semi Join Showplan Operator?

September 27, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Joins

It is very common of interviewers to ask questions which are a bit off and sometimes not used in daily life. Here is such question I heard the other dya. Question: What is Left Semi Join Showplan Operator? Answer: There are few interesting kinds of joint operations exists when execution…

Interview Question of the Week #037 – What are the Properties of Relational Tables?

September 20, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

The other day in the interview, I heard this question and it sent me back to my college days as I used to hear similar questions from my professors. Here is the same question again and its answer. Question: What are the properties of the relational tables? Answers: Relational tables have…

Interview Question of the Week #036 – What is the difference between @@DATEFIRST and SET DATEFIRST?

September 13, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL DateTime

Question: What is the difference between @@DATEFIRST and SET DATEFIRST with respect to SQL Server? Answer: SQL Server with US English as default language, SQL Server sets DATEFIRST to 7 (Sunday) by default. We can reset any day as the first day of the week using SET DATEFIRST 5 This will set…

SQL SERVER – How to View Objects in mssqlsystemresource System Database?

September 11, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

The series of interview questions are always fun. Sometimes I get to hear strange questions and are worth a detailed post. This blog is in continuation to one such question that landed into my Inbox which I personally felt had to have little explanation. During interviews there would be at…

Interview Question of the Week #035 – Different Ways to Identify the Open Transactions

September 6, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Question: What are different ways to identify open transactions in SQL Server? Answer: There are many ways to identify the open transactions. If there are some transactions which were started and not yet committed or rollback, you can use any of these to find them Use DBCC command There is a…

Interview Question of the Week #034 – What is the Difference Between Distinct and Group By

August 30, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Question: What is the difference between DISTINCT and GROUP BY? Answer: A DISTINCT and GROUP BY usually generate the same query plan, so performance should be the same across both query constructs. GROUP BY should be used to apply aggregate operators to each group. If all you need is to remove…