Do you know what is rank function?
Describe triggers features and limitations?
What is log ldf?
What do you mean by acid?
Can we rewrite subqueries into simple select statements or with joins? Example?
What is a cube? : sql server analysis services, ssas
How do you fine the performance tunning?
What are different type of Collation Sensitivity?
What are the types of indexes available with SQL Server?
Explain the architecture of ms sql reporting service?
How to use user defined functions in expressions?
Can a synonym name of a table be used instead of a table name in a select statement?
What are the database objects? : SQL Server Architecture