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 5083

How do you fine the performance tunning?

Accenture,

2 8640

what is diffence between replicaion and logshipping?

1 4290

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

2 8287

When do you create cluster and noncluster index?

Satyam,

5 10321

how can do you the system monitoring?

1 7209

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

2 4882

How the data stores in a page?

1 5539

what are the problems in logshipping?

3 22248

How to tune a stored procedure?

6 17170

what is index seek and index scan?

2 12270

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

ASD Lab, CSC, Intelligroup,

9 67616

What about UPDATESTATISTICS ?

HCL, Intelligroup,

2 6946

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

2 5927

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

4 8402

Un-Answered Questions { SQL Server }

What is role playing dimension with two examples? : sql server analysis services, ssas

1057

What is database black box testing?

1077

What is database dimension? : sql server analysis services, ssas

1144

What is Federation and Federation Member?

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

946

what is the system function to get the current user's user id? : Sql server database administration

1076

What is set nocount on and what is set nocount off?

999

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1077

What is the difference between stored procedure and user defined functions?

1242

Mention a few common trace flags used with sql server?

982

Difference between report and query parameter.

1146

How can you list all the columns in a database?

975

How to create hyperlink from returned sql query ?

1183

What is coalesce and check constraint in sql server?

1179

What is the exact numeric data type in sql?

1058

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