Interested to Buy Any Domain ? << Click Here >> for more details...
how to improve the speed of SQL database server and how to
avoid dead lock?
- 1 Answers
- 6106 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / indira gandhi
1.check th disc space u have to use
2.check the profile client have any job,and query problem
3.use update_satistics to update indexes
-------------------------
to avoid the deadlock
use nolock command in select staement
| Is This Answer Correct ? | 11 Yes | 5 No |
Post New Answer View All Answers
What are different types of views?
Explain how would you store your query in an SSRS report or a Database server?
Describe in brief databases and sql server databases architecture.
Describe how to use linked server?
Is sql server is free?
Define Joins?
What do you mean by an execution plan?
Explain syntax for dropping triggers?
What are indexers?
Give me any three differences between Truncate and Delete.
What is query parameter in ssrs?
Can we add an identity column to decimal datatype?
How to get the definition of a trigger back?
What are the differences between lost updates and uncommitted dependencies?
What are the acid properties?
