What is a mutating table error and how can you get around it?

1125

What is user defined stored procedures?

992

Tell me about joins in database system and explain each in detail.

1105

What is perspective, have you ever created perspective? : sql server analysis services, ssas

960

What is an example of a foreign key?

1029

Explain in brief about Microsoft SQL server?

1170

What are the 3 types of schema?

1174

What is a schema in ms sql server 2005?

1027

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1299

What is a covering index?

1040

List the different types of collation sensitivities in sql server?

1075

Define Unique Key?

1066

What is the difference between for auto and for nested?

1063

What are data files?

1091

where can you add custom error messages to sql server? : Sql server administration

1172