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 number sorts of privileges are accessible in sql?

1035

What are the difference between primary keys and foreign keys?

966

Define normalisation?

1116

How can you control the amount of free space in your index pages?

1057

What is sql sandbox in sql server?

1223

What is dbcc?

1139

How to delete exactly duplicate records from a table?

1063

What is the contrast amongst drop and truncate?

1034

What are data files?

1041

What is the difference between a clustered index and a non-clustered index?

991

What are the difference between clustered and a non-clustered index?

1043

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1206

What is the use of nvl work?

1004

How to optimize stored procedures in sql server?

1185

What is the difference between the 2 operating modes of database mirroring?

1111

Un-Answered Questions { SQL Server }

What are drilldown reports?

154

What is the use of custom fields in report?

1000

How many instances per computer are there in sql server 2000?

1076

what is a transaction? : Sql server database administration

992

What is the difference between DATETIME2 and DATETIME?

1080

What is a virtual table in sql?

996

What are approximate numeric data types in ms sql server?

1059

What are the disadvantages of primary key and foreign key in SQL?

1116

in the physical file layout, where should the transaction log be stored in relation to the data file?

994

Explain what are partitioned views and distributed partitioned views?

943

Explain security with sql azure?

186

How can you list all the columns in a database?

930

How do you rebuild an identity column?

949

What is format parameter in ssrs?

146

What are difference between Cluster index and Non-Cluster index?

1079

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