Do you know what guidelines should be followed to help minimize deadlocks?
Explain the benefits of user-defined functions?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Explain how dts is used to extract, transform and consolidate data?
Explain the difference between functions and stored procedures in sql server?
What do you know about normalization and de- normalization?
What is built-in function?
Explain database normalization?
Do you know exporting and importing utility?
Explain microsoft sql server functions?
What are scalar functions?
Explain steps of normalization?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
what is the system function to get current user's user id? : Sql server database administration
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration