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

1156

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

1045

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

1162

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

1177

What is lock escalation? : sql server database administration

1197

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

1076

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

1029

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

1081

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

990

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

973

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

1098

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

1373

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

1365

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

1209

Un-Answered Questions { SQL Server }

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2253

What new changes are being made in SQL Server?

1265

What is difference between count (*) and count 1?

970

How do database indexes work?

1055

What is tablesample?

1175

How many clustered indexes there can be on table ?

1069

What are tables in sql server?

1096

What are rows and columns?

1062

What is ssl in sql server?

1131

Explain mixed authentication mode of sql server?

1115

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1070

What is the difference between clustered and non-clustered indexes in ms sql server?

1050

What is temporal table?

934

How do I install sql server?

936

How to Check if table exists in sql server?

1185

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