Explain active/passive and active/active cluster configurations?
What are the kinds of subquery?
Can sql server 2016 run on windows 7?
Questions on identity?
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?
How to add additional conditions in SQL?
explain different types of constraints? : Sql server database administration
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
Explain multiserver query
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
What are explicit and implicit transactions?
Which data type columns are the best candidates for full-text indexing?
What are the different types of normalization?