Define outer join in sql server joins?
What is the simplest way to create a new database in ms sql server?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is partitioned view?
How to create a login account in ms sql server to access the database engine using "create login" statements?
How do you check the performance of a query and how do you optimize it?
How do you fine the performance tunning?
Does hive support indexing?
What do you know about normalization and de- normalization?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What is repeatable read?
What is the contrast between sql and pl/sql?
When you first load SQL SERVER you will startup with what all databases?