What is the partitioning method?
Can we return Data from 4(more than 1) tables in stored procedure?
What is data source view or dsv? : sql server analysis services, ssas
What is log cache in sql server?
Do you know what is replace and stuff function in sql server?
What is tcl in sql server?
What is difference between unique and primary key?
What is transaction server auto commit?
What is an example of a primary key?
How important do you consider cursors or while loops for a transactional database?
What is the difference between left and right outer join?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
How sql server executes a statement with nested subqueries?