Un-Answered Questions { SQL Server }

What do you know about normalization and de- normalization?

446


What is built-in function?

524


Explain database normalization?

627


Do you know exporting and importing utility?

509


Explain microsoft sql server functions?

519


What are scalar functions?

483


Explain steps of normalization?

507


explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

449


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

526


what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

496


what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

504


what are acid properties? : Sql server database administration

474


how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

443


explain how to create a new schema in a database? : Sql server database administration

559


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

464