how to improve the speed of SQL database server and how to
avoid dead lock?
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 is ms sql server triggers?
What is the meaning of sql server?
How adventureworkslt tables are related?
What is apply operator in sql?
What are the methods used to protect against sql injection attack?
What are temporal tables in sql server 2016?
How do I view a script in sql server?
what is normalization? Explain different levels of normalization? : Sql server database administration
what is the difference between Tabular and Matrix report?
What are the properties of the transactions?
What happens on checkpoint?
What is the process of normalization?
How to create a local temporary stored procedure?
What languages bi uses to achieve the goal?
Explain what are sparse columns?