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
- 6020 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 the use of tempdb? What values does it hold?
Why do we use trigger?
Explain timestamp datatype?
What are the 2 types of classifications of constraints in the sql server?
What is a non-clustered index?
Explain the collation?
What will be the maximum number of indexes per table?
What is index fragmentation in ms sql server?
Explain trigger and its types?
explain how to create a new schema in a database? : Sql server database administration
What is the command used to recompile the stored procedure at run time?
What is the difference between a "where" clause and a "having" clause?
Do you know what is normalization of database? What are its benefits?
What are click through reports?
What is SQL Azure Firewall?
