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
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
what are acid properties? : Sql server database administration
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
explain how to create a new schema in a database? : Sql server database administration
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
