how to improve the speed of SQL database server and how to
avoid dead lock?
- 1 Answers
- 5669 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
How ssrs maintain security?
What is the definition for sql server 2000?
What are truncate options available in sql server? : sql server database administration
What is primary key index?
What is partition in sql server?
how many no of arguments can be passed in procedures and functions
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is an indexed view?
What is the difference between for auto and for nested?
What is raid, and how it can influence database performance?
How exceptions can be handled in sql server programming?
Tell me what are the advantages of using stored procedures?
Explain the concept of recursive stored procedure.
What is inner join? Explain with an example?
Does server sql treat char as a variable-length or fixed-length column?
