explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
870what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
999what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
895how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
861there 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
870what is the difference between a primary key and a unique key? : Sql server database administration
961
Are resultset updatable?
How can I add Reporting Services reports to my application?
How the authentication mode can be changed?
What is the xml datatype?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is precedence constraint?
How sql server enhances scalability of the database system?
Which sql server table is used to hold the stored procedure script?
What is an inner join?
Give the query of getting last two records from the table in SQL SERVER?
Can we update data in a view?
What is transaction server distributed transaction?
What is #temp and @table variable in SQL server?
How many types of the database links?
How do you troubleshoot errors in a SQL Server Agent Job?