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 purpose of sql profiler in sql server? : sql server database administration

1164

Can we perform backup restore operation on tempdb? : sql server database administration

1051

Can you move the resources after pausing the node? : sql server database administration

1171

What should be the fill factor for indexes created on tables? : sql server database administration

1184

What is lock escalation? : sql server database administration

1201

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

1084

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

1032

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

1082

What are the difference between primary key and unique key? : sql server database administration

994

Can you tell me some of the common replication dmv's and their use? : sql server replication

980

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1104

What type of locking occurs during the snapshot generation? : sql server replication

1377

Explain what stored procedure sp_replcounters is used for? : sql server replication

1577

What are the different types of sql server replication? : sql server replication

1373

How will you monitor replication latency in transactional replication? : sql server replication

1213

Un-Answered Questions { SQL Server }

What are different types of join?

1378

How to get all stored procedures in sql server?

1064

How would you choose between a clustered and a non-clustered index?

1023

What is primary key and example?

998

Explain about nested stored procedure?

1084

What is a primary index?

980

What is trigger explain with program?

1019

What is temporary table in sql server? Why we use temp table?

997

Explain about system database?

1110

What is a result set object returned by odbc_exec()?

1079

what authentication modes does sql server support? : Sql server database administration

1191

Do you know what is bit data type and whats the information that can be stored inside a bit column?

1001

What is page in sql server?

997

Write a SQL query to delete a table?

1186

How to rename an existing column with sql server management studio?

1057

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