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 the purpose of sql profiler in sql server? : sql server database administration
What is data set in report?
how to trace the traffic hitting a sql server? : Sql server database administration
your distribution database is full what will u do
How to connect Azure federated root database and apply federation in entity framework?
when would you go for denormalization? : Sql server database administration
How do we Backup SQL Azure Data?
What are examples of triggers?
What is temporary stored procedure?
what is the difference between Delete and Truncate command in SQL
What is implicit cursors?
What are the differences between having and where clause.
What is a ddl statement?
What are character string data types in ms sql server?
What are sql server procedures?