explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?
What is normalization of database? What are its benefits?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
what are the new features of sql server 2005?
8 Answers HP, Keane India Ltd,
What are the type of Indexes? which one is best, why?
How global temporary tables are represented and its scope?
How many types of keys are there?
How to avoid cursors?
3 Answers CarrizalSoft Technologies, HP,
When is update_statistics command used?
What is index, cluster index and nonclustered index?
What is live lock and deadlock? what is Lock escalation?
Explain few of the new features of sql server 2008 management studio