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 explicit mode in sql server?

1109

What is logon trigger?

1156

How to Update from select query in sql server?

1114

What is system stored procedures?

1082

What is sql injection? How to protect against sql injection attack?

1036

What is repeatable read?

1091

What is a rollup clause?

1017

How can I know what locks are running on which resource?

993

When I delete any data from a table, does the sql server reduce the size of that table?

1061

What is user-defined functions? What are the types of user-defined functions that can be created?

1078

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1123

How to find the list of fixed hard drive and free space on server?

1279

What is difference in performance between insert top (n) into table and using top with insert?

1117

What is change data capture (cdc) in sql server 2008?

1078

Where are sql server usernames and passwords stored in the sql server?

1170

Un-Answered Questions { SQL Server }

What do you mean by subquery?

1145

What is a transactions?

1083

What is difference between clustered and non clustered index?

1032

Explain how to maintain a fill factor in existing indexes?

1035

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1180

Define compound operators?

964

What is query cost in sql server?

1037

Characterize join and name diverse sorts of joins?

1021

When I run the sql server 2000 setup, it just hangs. What do I do?

1126

Differentiate between ms sql server reporting services vs crystal reports?

946

What do you understand by a view?

1046

What is the purpose of linked server configuration in sql server?

1091

How do I find sql server instance name?

1007

Explain about builtinadministrator?

1114

How many databases Microsoft SQL server provides?

1150

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