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?

1014

What is self contained scalar sub query?

974

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

989

Find nth lowest salary or get nth lowest salary?

1023

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

1018

What is instead of dml trigger?

997

Explain different types of self contained sub query?

1027

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

955

Explain relational data?

921

What are the different normalization forms?

1104

Explain primary key, foreign key and unique key?

987

What is clr ddl trigger?

958

How to stop log file growing too big?

1012

How to enable/disable indexes?

1064

Difference between Inner vs outer joins?

946

Un-Answered Questions { SQL Server }

List the data types available in mssql?

1028

What are the database roles? : sql server security

1178

What are number line correlation administrators will use while working with a subquery?

1172

what are constraints? Explain different types of constraints? : Sql server database administration

978

How to stop a loop early with break statements in ms sql server?

1018

What do you think of this implementation? Can this be implemented better?

934

explain extended properties

987

Which Model uses the SET concept

982

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

920

What is abstracting periodical?

941

What is a group function explain with an example?

984

What are the dmvs?

1010

What is the fillfactor concept in indexes?

980

What are trace flags?

1030

How do I clean up sql server transaction log?

1060

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