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 4977

How do you fine the performance tunning?

Accenture,

2 8524

what is diffence between replicaion and logshipping?

1 4201

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

2 8194

When do you create cluster and noncluster index?

Satyam,

5 10120

how can do you the system monitoring?

1 7141

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

2 4781

How the data stores in a page?

1 5424

what are the problems in logshipping?

3 22104

How to tune a stored procedure?

6 16956

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 67239

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 8257

Un-Answered Questions { SQL Server }

What are system databases in ms sql server?

1056

What is default constraint?

995

What do you mean by an execution plan? Why is it used?

1024

Is sql server 2016 free?

935

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1145

How to create function without parameter in sql server?

1054

What is the difference between clustered index and primary key?

921

What are the differences between left join and inner join in sql server?

1107

Can a trigger be created on a view?

956

Do you know what are various aggregate functions that are available?

1124

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1130

Write a code to select distinct records without using the DISTINCT keyword.

1114

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

1190

How to delete an existing database user?

1017

What is exporting utility?

1021

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