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

1099

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

990

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

1093

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

1133

What is lock escalation? : sql server database administration

1154

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

1032

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

969

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

1013

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

936

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

919

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

1035

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

1328

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

1503

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

1258

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

1134

Un-Answered Questions { SQL Server }

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1033

Explain the disadvantages of cursors?

1135

What is the difference between coalesce() & isnull()?

1128

What are ddl (data definition language) statements for tables in ms sql server?

1095

what is the difference between Tabular and Matrix report?

170

Explain DBCC?

955

Explain a join?

1062

What is a unique key constraint?

1024

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

904

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1070

How to how to convert numeric expression data types using the convert() function??

1044

How to get the definition of a stored procedure back?

975

User wants only to display only pdf as export option in report manager. How to achieve this?

262

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

918

How do you check sql server is up and running?

990

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