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 5087

How do you fine the performance tunning?

Accenture,

2 8647

what is diffence between replicaion and logshipping?

1 4291

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

2 8287

When do you create cluster and noncluster index?

Satyam,

5 10327

how can do you the system monitoring?

1 7209

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

2 4885

How the data stores in a page?

1 5543

what are the problems in logshipping?

3 22249

How to tune a stored procedure?

6 17179

what is index seek and index scan?

2 12274

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

ASD Lab, CSC, Intelligroup,

9 67624

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 5933

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

4 8407

Un-Answered Questions { SQL Server }

What are sql server procedures?

1037

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1569

Explain can you implement data mining in ssrs?

161

What is an expensive query?

976

Please illustrate physical database architecture? : SQL Server Architecture

1034

How to retrieve field values using mssql_result()?

1429

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1271

Can We Use Data-grids For Our Report In Ssrs?

188

How to enter date and time literals in ms sql server?

1073

What is dbcc? Give few examples.

1086

What happens if date-only values are provided as date and time literals?

1080

How can you insert null values in a column while inserting the data?

1348

How to change the ownership of a schema in ms sql server?

1268

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1308

what are candidate key, alternate key and composite key? : Sql server database administration

970

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