how to improve the speed of SQL database server and how to
avoid dead lock?
Answer / 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 |
What is Sqlpaging in SqlServer 2005 ?
What are the 7 disadvantages to a manual system?
How to attach adventureworkslt physical files to the server?
What is spatial and temporal data?
what are the advanced features in sql 2008?
What is a linked server in sql server?
How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)
What is difference between clustered index and non clustered index?
How to delete database objects with "drop" statements in ms sql server?
What are the advantages of using cte?
Explain what is row_number function?
which one will take 1st priority in case of insert statement and select statement???