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
- 6125 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 is resultset concur_updatable?
what is spatial nonclustered index
Can you explain important index characteristics?
Explain about service Broker functions?
Write a SQL query to make a column as unique?
Why use identity in sql server?
Explain the difference between HTTP and HTTPS in database?
What are the different kinds of ssrs reports?
Can we install sql server 2016 on windows 7?
what is the system function to get the current user's user id? : Sql server database administration
What are translations and its use? : sql server analysis services, ssas
how to avoid cursors? : Sql server database administration
Difference between 2NF &3NF ?
Can the query output be sorted by multiple columns in ms sql server?
What are different types of replication in sql server?
