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

Explain few of the new features of sql server 2008 management studio

973

What are “lost updates”?

1043

What command do we use to rename a db, a table and a column?

978

What is the difference between a function and a trigger?

1122

What is t-sql script to take database offline – take database online.

1134

What is a filestream?

1045

What is difference between commit and rollback when used in transactions?

1016

Data table as parameter in sql server?

1102

What is the xml datatype?

1122

What is the difference between index seek vs. Index scan?

1062

What is set nocount on and what is set nocount off?

993

Explain intellisense for query editing

1074

Explain primary key and foreign key constraints?

1089

Explain following error properties?

1060

Explain system scalar functions?

1043

Un-Answered Questions { SQL Server }

Define union, union all, minus, intersect?

1032

How to transfer data from a cursor to variables with a "fetch" statement?

1141

What is the difference between Stored Procedures and triggers?

1131

How many types of subqueries are there in sql server?

1031

What is the report model project?

151

Can you roll back the ddl statement in a trigger?

1019

What are the differences between union, intersect, and minus operators?

1139

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1081

How to choose all records from the table?

1102

How to backup SQL Server Reporting Services ?

152

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1871

what does the automatic recovery do? : Sql server administration

1078

How to restore performance issues and how to check?

2051

explain the storage models of olap? : Sql server database administration

1009

What is the default Port No on which SQL Server listens?

1175

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