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 12115

what is difference between Enterprise Manager and Query Analyer

CTS,

6 9586

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

Synergy,

1 6345

what is DTS what are tasks available

Wipro,

1 3818

Normalization and denormalization

Wipro,

3 6833

Diffrent types of function

Wipro,

1 4441

diffrence between function and procedure

Wipro,

5 7388

diffrence between Cluster Index and non Cluster Index

Wipro,

3 6215

System variable and temporary variables

Wipro,

2250

optimization techinques

Wipro,

2675

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 5051

Un-Answered Questions { SQL Server }

what are different types of backups available in sql server? : Sql server database administration

935

Do you know what are pages and extents? : SQL Server Architecture

995

What is side by side migration in sql server?

1103

How to delete a database in ms sql server?

1234

Where sql server user names and passwords are stored in sql server? : sql server database administration

1053

explain what is raid and what are different types of raid configurations? : Sql server database administration

1002

What are the components of sql server service broker?

1016

1 01 101 01010

2054

How do you clear a log file?

1047

How can you stop stored procedures from recompiling?

900

Can we write ddl in trigger?

918

What is dbcc command in sql server?

1091

What is clustered vs nonclustered index?

946

Explain the rules for designing files and file groups in sql server?

987

How to update values in a table with update statements in ms sql server?

1013

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