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

1105

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

998

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

1102

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

1138

What is lock escalation? : sql server database administration

1159

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

1037

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

975

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

1015

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

941

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

927

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

1043

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

1332

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

1518

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

1270

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

1143

Un-Answered Questions { SQL Server }

What are the components of dbms?

954

Explain primary key and foreign key constraints?

1031

What is the largest component inside a field?

1127

Are resultset updatable?

951

Do you know what are the steps to process a single select statement?

973

How to create stored procedures with parameters in ms sql server?

1079

What is create command?

968

Can a table be moved to different filegroup?

976

Will sql server 2005 allow you to reduce the size of a column?

991

What is filtered index?

1095

What is indexing in sql server with example?

1001

What is inner join in sql server joins?

1035

What is cursors?

1186

How to enter date and time literals in ms sql server?

1016

What does set rowcount do?

909

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