What are the basic functions for master, msdb, model, tempdb and resource databases?

984

How can I know what locks are running on which resource?

949

What is user defined datatypes and when you should go for them?

1014

Do you know spatial data types - geometry and geography in sql server 2008?

1029

What is mean by candidate key?

1003

What is the fillfactor concept in indexes?

980

How will you add a dimension to cube? : sql server analysis services, ssas

1082

What is the correct order of the logical query processing phases?

931

What is the use of custom fields in report?

998

How to create a view on an existing table in ms sql server?

1126

What do you understand by a stored procedure?

1088

What are the difference between primary key and unique key? : sql server database administration

936

What is sql server replication? : sql server replication

978

To which devices can a backup be created and where should these devices be located? : sql server management studio

1038

Explain how many normalization forms?

1027