explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
940what is the system function to get current user's user id? : Sql server database administration
1050what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
1108what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
1001how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
960there 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
968what is the difference between a primary key and a unique key? : Sql server database administration
1044
What is after dml trigger?
Can you tell me some of the common replication dmv's and their use? : sql server replication
Explain the xml support sql server extends?
Explain the types of indexes.
Give a example to search fr a string in all stored procedure in sql server.
Explain what is the difference between union and union all?
What are the two authentication modes in sql server?
What is the ‘fillfactor’?
What is compound operators?
What are the components of sql server service broker?
What is 2nf example?
What is intellisense?
When should you use an instead of trigger?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
Do you know what are pages and extents? : SQL Server Architecture