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

How to list all stored procedures in the current database using ms sql server?

1126

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1024

How to create user defined functions with parameters?

1221

How to create a view using data from another view?

946

How to drop an existing user defined function in ms sql server?

1023

How to execute the cursor queries with "open" statements?

1175

How to configure odbc dsn with different port numbers?

1083

What happens if null values are involved in bitwise operations?

1014

How to delete multiple rows with one delete statement in ms sql server?

1010

How to create a view on an existing table in ms sql server?

1122

How to change the password of a login name in ms sql server?

1009

Why I am getting this error when dropping a database in ms sql server?

1072

Why I can not enter 0.001 second in date and time literals in ms sql server?

1054

How to loop through the result set with @@fetch_status?

1339

What is the impact on other user sessions when creating indexes?

918

Un-Answered Questions { SQL Server }

What is the bookmark lookup and rid lookup?

996

What is a join in sql? What are the types of joins?

1093

What are “unrepeatable reads”?

1228

what is the difference between a primary key and a unique key? : Sql server database administration

993

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1082

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1000

What is collation?

1136

Which language rdl files made of?

130

What is the impact on other user sessions when creating indexes?

918

Explain what you mean by 3 tier architecture.

1071

What are the types of database schema? : sql server analysis services, ssas

1126

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

969

Is sql server difficult to learn?

914

When would you use sql joins?

951

What is mssql?

980

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