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

1355

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

1045

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

1154

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

1113

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

1081

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

1205

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

1102

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

1003

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

1053

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

1088

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

1129

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

1159

What are the dmvs? : sql server database administration

1122

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

1032

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

1073

Un-Answered Questions { SQL Server }

Explain the benefits of user-defined functions?

1124

Explain why variables called the most powerful component of ssis?

1178

What is view in sql?

955

How can I check if a view exists in a sql server database?

1085

Explain important index characteristics?

1083

What are the results of running this script?

978

How many joins in sql server?

1004

What is a filestream?

1050

What are window functions in sql server?

1068

What is an indexing technique?

988

When is update_statistics command used?

1090

Why do we use trigger?

1029

Can we use pragma autonomous_transaction in trigger?

1018

What is the difference between NOROW and LOCKROW?

2906

How do you open a cluster administrator?

1099

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