Explain syntax for disabling triggers?
Define left outer join?
How dts is used to extract, transform and consolidate data?
How to implement service broker?
What is fill factor and pad index?
What are constraints in microsoft sql server?
What is user-defined function?
What guidelines should be followed to help minimize deadlocks?
Differentiate between ms sql server reporting services vs crystal reports?
What is the use of keyword with encryption.
What is default constraint in ms sql server?
Explain transaction server explicit transaction?
What is exporting utility?
What is the use of keyword with encryption. Create a store procedure with encryption?
Explain time data type in sal server 2008?