Why transaction is important?

975

Explain four layers of abstraction microsoft architectured?

147

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

983

how many type of indexing in database?

975

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1019

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1961

Where are SQL server users names and passwords are stored in sql server?

1261

Can sub report data source be different from that of the parent report?

143

What is used to replicate sessions between instances in coldfusion clusters?

1070

what is the system function to get the current user's user id? : Sql server database administration

1012

What is the difference in accessing db between sql server vs sql azure?

174

What is tcl in sql server?

1120

Do you know what are the differences between lost updates and uncommitted dependencies?

1073

What is relationship? What number of sorts of relationship are there?

1134

Can we use trigger new in before insert?

919