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 4867

How do you fine the performance tunning?

Accenture,

2 8422

what is diffence between replicaion and logshipping?

1 4138

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

2 8091

When do you create cluster and noncluster index?

Satyam,

5 9928

how can do you the system monitoring?

1 7075

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

2 4700

How the data stores in a page?

1 5343

what are the problems in logshipping?

3 21933

How to tune a stored procedure?

6 16759

what is index seek and index scan?

2 12052

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

ASD Lab, CSC, Intelligroup,

9 66904

What about UPDATESTATISTICS ?

HCL, Intelligroup,

2 6747

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

2 5719

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

4 8099

Un-Answered Questions { SQL Server }

How is a full-text index updated?

906

Is oracle faster than sql server?

900

What do you mean by recursive stored procedure?

896

What are the benefits and tasks of object explorer? : sql server management studio

1129

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1705

What is a domain constraint give an example?

1012

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

972

How to delete multiple rows with one delete statement in ms sql server?

956

What is the syntax to execute the sys.dm_db_missing_index_details?

974

Can you import Microsoft Excel data to SSRS?

126

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1031

Why do we use functions?

860

How to remove duplicate rows from table except one?

956

Define primary key?

1085

What method is used by the Command classes to execute SQL statements that return single values?

1019

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