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?

1059

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

988

How to create user defined functions with parameters?

1167

How to create a view using data from another view?

907

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

982

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

1101

How to configure odbc dsn with different port numbers?

1030

What happens if null values are involved in bitwise operations?

968

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

945

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

1055

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

963

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

1025

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

1013

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

1257

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

876

Un-Answered Questions { SQL Server }

Explain DBCC?

911

What are a database and a data warehouse?

972

What does set rowcount do?

868

Explain transaction server isolation?

982

What is use of @@ spid in sql server?

1150

Do you know what guidelines should be followed to help minimize deadlocks?

924

how many clustered indexes can be created on a table? : Sql server database administration

1069

What is sql azure database?

206

how to control the amount of free space in your index pages? : Sql server database administration

985

Explain why variables called the most powerful component of ssis?

996

What is stored in the mssqlsystemresource database? : sql server database administration

990

What is a scheduled job or what is a scheduled task?

918

How many types of the database links?

1025

Tell me when is the update_statistics command used?

1021

What does asynchronous call backs means?

1075

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