What are the basic functions for master, msdb, model, tempdb and resource databases?
How can I know what locks are running on which resource?
What is user defined datatypes and when you should go for them?
Do you know spatial data types - geometry and geography in sql server 2008?
What is mean by candidate key?
What is the fillfactor concept in indexes?
How will you add a dimension to cube? : sql server analysis services, ssas
What is the correct order of the logical query processing phases?
What is the use of custom fields in report?
How to create a view on an existing table in ms sql server?
What do you understand by a stored procedure?
What are the difference between primary key and unique key? : sql server database administration
What is sql server replication? : sql server replication
To which devices can a backup be created and where should these devices be located? : sql server management studio
Explain how many normalization forms?