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 6937

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 12118

what is difference between Enterprise Manager and Query Analyer

CTS,

6 9591

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

Synergy,

1 6347

what is DTS what are tasks available

Wipro,

1 3819

Normalization and denormalization

Wipro,

3 6835

Diffrent types of function

Wipro,

1 4442

diffrence between function and procedure

Wipro,

5 7394

diffrence between Cluster Index and non Cluster Index

Wipro,

3 6216

System variable and temporary variables

Wipro,

2250

optimization techinques

Wipro,

2676

user defined datatypes

Wipro,

1 4497

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

1916

Magic Tables ?

Thomson Reuters,

2 6383

Diffrences between sql server 2000 vs 2005

Thomson Reuters,

2 5052

Un-Answered Questions { SQL Server }

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1171

What is the use of @@spid?

1001

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1089

how to define testing of network layers? : Sql server database administration

972

How to Insert multiple rows with a single insert statement?

1054

What is exporting and importing utility?

1086

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1903

What is auditing in sql server?

927

How do you rebuild an identity column?

949

What is policy management?

996

Define tempdb database?

996

what is the difference between count(*) and count(1) ?

1085

What is the purpose of the model database?

1015

What is factless fact table? : sql server analysis services, ssas

1028

How do you delete a trigger?

979

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