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?

1113

What is logon trigger?

1165

How to Update from select query in sql server?

1123

What is system stored procedures?

1089

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

1045

What is repeatable read?

1098

What is a rollup clause?

1022

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

1002

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

1065

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

1087

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

1128

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

1288

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

1124

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

1080

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

1176

Un-Answered Questions { SQL Server }

What Are the Main Features of SQL Azure?

121

Does group by or order by come first?

1005

How to create function with parameter in sql server?

1158

how can u get last observation in an unknown dataset ?

2492

Do you know the isolation level that sql server support?

1005

Where cross join is used?

1037

Explain features and concepts of analysis services?

1025

How do I manually uninstall an instance of sql server 2016?

1085

What is SQL Azure?

107

how to use DTS package in 2000,2005,2008 in sql server

1906

How do you drop an index?

975

What is a data source or ds? : sql server analysis services, ssas

1053

What are the features of Embedded SQL

1177

What is triggers and its types?

1070

What do you understand by user-defined function in the sql server?

1013

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