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

1264

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

982

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

1075

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

1046

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

1030

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

1153

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

1043

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

935

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

1012

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

1030

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

1083

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

1106

What are the dmvs? : sql server database administration

1058

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

986

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

1025

Un-Answered Questions { SQL Server }

What is the purpose of data source?

1038

What is sqlservr.exe - process - sql server (sqlex?press)?

1108

How to get a list of columns in a view using "sys.columns" in ms sql server?

991

Tell me what do we need queues in sql service broker?

992

Explain optimistic and pessimistic concurrency?

993

What is the largest component inside a field?

1127

Are connections to sql server encrypted?

1003

Explain error and transaction handling in sql server?

1012

What is amo? : sql server analysis services, ssas

1089

Tell me what is difference between clustered and non clustered index?

944

Can a cursor be updated? If yes, how you can protect which columns are updated?

1110

Do you know what is a linked server in sql server?

1024

Do you know query execution plan?

1173

What are the advantages of stored procedure in sql server?

892

Do you know what is sql injection?

998

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