SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

what is the disadvantage of SQL Loder?

1 7017

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

TCS,

7 12323

what is difference between Enterprise Manager and Query Analyer

CTS,

6 9783

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

Synergy,

1 6426

what is DTS what are tasks available

Wipro,

1 3905

Normalization and denormalization

Wipro,

3 6952

Diffrent types of function

Wipro,

1 4516

diffrence between function and procedure

Wipro,

5 7593

diffrence between Cluster Index and non Cluster Index

Wipro,

3 6347

System variable and temporary variables

Wipro,

2302

optimization techinques

Wipro,

2721

user defined datatypes

Wipro,

1 4571

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1962

Magic Tables ?

Thomson Reuters,

2 6487

Diffrences between sql server 2000 vs 2005

Thomson Reuters,

2 5154

Un-Answered Questions { SQL Server }

List the advantages of using stored procedures?

1112

How to run sql server 2005 books online on your local system?

1006

How do you delete duplicate rows in sql server?

1009

What is a transaction and why is it important?

1170

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

1030

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1102

What are different types of statements that are supported by sql?

1101

mention different types of relationships in the dbms?

1094

Should you normalize audio?

1010

What are four major operators that can be used to combine conditions on a where clause?

1093

What is “asynchronous” communication in sql server service broker?

1082

What are relationships and mention different types of relationships in the dbms

1016

What is the use of group by clause?

996

What factors you will consider calculating the storage requirement for that view?

995

How to list all user defined functions in the current database?

1121

For More Un-Answered { SQL Server } Questions Click Here