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 the status of services on passive node for failover cluster in sql server? : sql server database administration

1253

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

976

What is replication with database mirroring? : sql server database administration

1069

What is your recommendation for a query running very slow? : sql server database administration

1039

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

1025

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1144

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1038

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

929

What are system databases into sql server (2005/2008) : sql server database administration

1003

What are truncate options available in sql server? : sql server database administration

1020

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1081

What is database isolation in sql server? : sql server database administration

1097

What are the dmvs? : sql server database administration

1050

What is policy based management (pbm)? : sql server database administration

977

Where can you find the error log information? : sql server database administration

1021

Un-Answered Questions { SQL Server }

What kind of problems occurs if we do not implement proper locking strategy?

1395

Explain concepts of analysis services?

952

Can truncate be rolled back?

933

What are the basic functions for master, msdb, model, tempdb and resource databases?

983

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8150

What are the different types of join?

1165

What is raid and what are different types of raid levels?

1142

Explain primary key in sql server?

1014

What is normalization 1nf 2nf 3nf?

1058

Disadvantages of the indexes?

1114

How to convert a numeric expression from one data type to another?

1008

What is abstracting periodical?

939

How to declare and use cursor variables?

1159

How to get the definition of a stored procedure back?

975

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1322

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