## Answer -Question of the Week – 2/1/2014 – Question 1

Question :- Suppose we have to design a database in which employees can work on multiple projects.There are many designation defined in the organization to which each employee can belongs.   For example, Software engineer, Team lead, Project Manager, Project lead, QC engineer, QC Lead, QC manager etc. An employee can belong to one designation […]

## Answer – Objective Question (Which table is called Heap table in SQL Server)

Question:-    Which table is called Heap table in SQL Server. 1) Table without any indexes 2) Table without any clustered index (Correct Answer) 3) Table without any non clustered Index 4) None of the above Many people attempted this question and mostly gives the correct answer. The correct answer is option 2 ( Table […]

## Question of the Week – 2/1/2014 – Question 1

Question :- Suppose we have to design a database in which employees can work on multiple projects.There are many designation defined in the organization to which each employee can belongs.  For example, Software engineer, Team lead, Project Manager, Project lead, QC engineer, QC Lead, QC manager etc. An employee can belong to one designation at […]

## Answer – Objective Question (Number of non clustered indexes possible on a Table in SQL Server 2008R2)

Question :-  How many non clustered indexes are possible in a table in SQL Server 2008R2 1)  1 2) 249 3) 999  (Correct answer) 4) None of these Explanation  21 people gives answer to this Question and most of them is correct. Correct answer is 999 (Option 4). In SQL Server 2008 onwards, we can […]

## Answer – Question of the Week – 28/12/2013 – Question 2

Question:- Suppose we have a table named tbl_charactername have only one column say “charactername”. It contains 10 rows. First 5 rows contains “Vivek Johari” and the next 5 rows contains “Abhinav Golwalkar” tbl_charactername ——————— Vivek Johari Vivek Johari Vivek Johari Vivek Johari Vivek Johari Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Now we […]

## Deleting Duplicate rows using CTE

Deleting Duplicate rows using CTE Many times we caught in a situation where we have a table where there is no primary or unique column defined in it and rows with duplicate data inserted in the table. In this example I will tries to show how to delete the duplicate rows using CTE. Suppose we […]

## Answer -Question of the Week – 25/12/2013- Question 1

Question:- Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150)) Suppose it contains the following data:- Studentid  Studentname 1               Vivek Johari 2               Chandra Singh 4           […]

## Question of the Week – 28/12/2013 – Question 2

Question:- Suppose we have a table named tbl_charactername have only one column say “charactername”. It contains 10 rows. First 5 rows contains “Vivek Johari” and the next 5 rows contains “Abhinav Golwalkar” tbl_charactername ——————— Vivek Johari Vivek Johari Vivek Johari Vivek Johari Vivek Johari Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Now […]

## Question of the Week -25/12/2013- Question1

Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150)) Suppose it contains the following data:- Studentid   Studentname  1               Vivek Johari 2              Chandra Singh 4             […]

## Interview Questions on Sql Server -Part 3

1. What are the Sql Joins? Sql Joins are the way to get data from many tables based on some logical conditions. The different  types of Joins in Sql Server are 1) Inner join or Equi join 2) Self Join (it can be considered as the part of Inner join) 3) Outer Join 4) Cross […]