What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is the New in SQL server 2008?
What are the types of indexes?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Explain four layers of abstraction microsoft architectured?
What are the advantages of sql azure?
What encryption security is available in sql azure?
Explain security with sql azure?
Can I use sql azure as a backup with log shipping or database mirroring?
What is it’s similarity with sql server?
What are horizontal and vertical scaling?
What are rest-style architecture's?
What is the data tier application?
How do you handle datasets larger than 50 gb?