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 query and condition to delete datas in sql server.

2 4979

How do you fine the performance tunning?

Accenture,

2 8524

what is diffence between replicaion and logshipping?

1 4202

what is physical sort data and logical sort data in index?

2 8197

When do you create cluster and noncluster index?

Satyam,

5 10121

how can do you the system monitoring?

1 7143

what is the Enterprise manager(2000) and management studio (2005)?

2 4782

How the data stores in a page?

1 5424

what are the problems in logshipping?

3 22107

How to tune a stored procedure?

6 16958

what is index seek and index scan?

2 12154

What is the difference between IN and EXISTS operators in SQL Server?

ASD Lab, CSC, Intelligroup,

9 67246

What about UPDATESTATISTICS ?

HCL, Intelligroup,

2 6843

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 5810

can you any body tell me the difference between candidate key and primary key

4 8262

Un-Answered Questions { SQL Server }

What is precedence constraint?

983

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1120

How can I know what locks are running on which resource?

957

What are the types of sql server?

1052

Explain the different index configurations a table can have?

945

Explain filtered indexes?

1001

Explain how dts is used to extract, transform and consolidate data?

998

What is difference between equi join and inner join?

950

Can you explain full-text query in sql server?

1011

Explain Normalization and DE normalization

1110

What is unique key constraint?

1060

How to select true false based on column value in sql server?

1033

Explain what are the events recorded in a transaction log?

1005

What is query optimization process?

1011

What is the bookmark lookup and rid lookup?

998

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