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 6935

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 12096

what is difference between Enterprise Manager and Query Analyer

CTS,

6 9570

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

Synergy,

1 6334

what is DTS what are tasks available

Wipro,

1 3809

Normalization and denormalization

Wipro,

3 6823

Diffrent types of function

Wipro,

1 4436

diffrence between function and procedure

Wipro,

5 7359

diffrence between Cluster Index and non Cluster Index

Wipro,

3 6212

System variable and temporary variables

Wipro,

2248

optimization techinques

Wipro,

2667

user defined datatypes

Wipro,

1 4493

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

1908

Magic Tables ?

Thomson Reuters,

2 6379

Diffrences between sql server 2000 vs 2005

Thomson Reuters,

2 5043

Un-Answered Questions { SQL Server }

What are types of scd? : sql server analysis services, ssas

1010

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

967

What are security principals used in sql server 2005?

976

What are the different methods available under sqlcommand class to access the data?

1118

What are the difference between clustered and a non-clustered index?

1038

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1038

how to use DTS package in 2000,2005,2008 in sql server

1831

What the different topologies in which replication can be configured?

1083

What are system databases into sql server (2005/2008)?

996

Differentiate sql server reporting services vs. Crystal reports?

200

Explain the truncate command?

975

What are the different editions available in sql server 2000?

1046

What is the full form of ddl?

921

What programming language would you use to create embedded functions in ssrs?

184

How many types of triggers are there?

1060

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