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

1107

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

1039

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

977

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

928

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

1044

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

1272

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

1143

Un-Answered Questions { SQL Server }

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1631

How column data types are determined in a view?

961

Define union, union all, minus, intersect?

979

What is normalization? Explain different forms of normalization?

1160

What happens if ntwdblib.dll is missing on your machine?

1144

What is the bookmark lookup and rid lookup?

998

When I delete any data from a table, does the sql server reduce the size of that table?

1018

What stored by the master? : sql server database administration

1110

What is the maximum size of sql server database?

1009

In what three ways is the return statement used in a stored procedure?

1008

What is the purpose of a table?

959

Can a table be moved to different filegroup?

976

Do you know spatial data types - geometry and geography in sql server 2008?

1033

What does set rowcount do?

909

How can you stop stored procedures from recompiling?

900

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