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 4962

How do you fine the performance tunning?

Accenture,

2 8513

what is diffence between replicaion and logshipping?

1 4194

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

2 8190

When do you create cluster and noncluster index?

Satyam,

5 10106

how can do you the system monitoring?

1 7135

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

2 4772

How the data stores in a page?

1 5422

what are the problems in logshipping?

3 22068

How to tune a stored procedure?

6 16925

what is index seek and index scan?

2 12145

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

ASD Lab, CSC, Intelligroup,

9 67193

What about UPDATESTATISTICS ?

HCL, Intelligroup,

2 6832

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

2 5804

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

4 8233

Un-Answered Questions { SQL Server }

Explain about Normalization?

1054

What are out-of-range errors with date and time literals?

1025

How do you delete duplicate records in sql server?

1048

Explain the third normal form(3nf)?

936

What is the exact numeric data type in sql?

998

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1072

Determine when to use stored procedure to complete sql server tasks?

1048

Explain system views?

1079

Explain about thread and memory management process of SQL?

967

what is the difference between count(*) and count(1) ?

1079

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1059

What are data resources?

906

How many types of the database links?

1066

Explain tables in SQL Azure?

120

what's sql server? : Sql server database administration

991

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