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 does top operator do?

1081

What is self contained scalar sub query?

1022

How can I get data from a database on another server?

1055

Find nth lowest salary or get nth lowest salary?

1092

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1082

What is instead of dml trigger?

1059

Explain different types of self contained sub query?

1107

What is the difference between grant and with grant while giving permissions to the user?

1027

Explain relational data?

969

What are the different normalization forms?

1168

Explain primary key, foreign key and unique key?

1024

What is clr ddl trigger?

1037

How to stop log file growing too big?

1066

How to enable/disable indexes?

1129

Difference between Inner vs outer joins?

988

Un-Answered Questions { SQL Server }

What is the new security features added in sql server 2016? : sql server security

1168

How many clustered indexes there can be on table ?

1075

What are the differences between decimal and float in ms sql server?

1357

How to connect to SQL Azure Database by using sqlcmd?

140

How to Sync Two SQL Azure Databases?

121

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1169

Describe different Processing Modes offered by SSRS?

258

How you can get the list of largest tables in a database?

1074

What is difference between rollback immediate and with no_wait during alter database?

1138

What do you understand by the analysis services in sql server?

986

explain different types of cursors? : Sql server database administration

1150

What is database replication? What are the different types of replication you can set up in sql server?

1019

What are pessimistic lock and optimistic lock?

1146

Can I save my report as html, excel or word? : sql server management studio

1013

What is clustered vs nonclustered index?

1005

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