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

1346

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

1038

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

1148

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

1110

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

1078

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

1199

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

1097

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

1000

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

1051

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

1081

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

1125

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

1152

What are the dmvs? : sql server database administration

1118

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

1029

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

1071

Un-Answered Questions { SQL Server }

How to define output parameters in stored procedures?

1081

How can you find out how many rows returned in a cursor?

1082

Define constraints and give an example of their use?

1093

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1036

Explain about Views?

1121

How do I know if localdb is running?

998

List the different index configurations possible for a table?

978

What xml support does the sql server extend?

1056

How to create an inline table-valued function?

1020

How to list all tables in the database using odbc_tables()?

1114

How to use clusters?

1014

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

1004

How to create sub reports?

251

What is cube dimension? : sql server analysis services, ssas

1048

What extended events?

1062

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