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
- 6119 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 collation sensitivity?
What do you understand by a stored procedure?
What are the different types of replication are there in sql server 2000?
How many joins in sql server?
Differentiate between ms sql server reporting services vs crystal reports?
Is mysql the same as sql server?
When should you use an instead of trigger?
What are the disadvantages of merge replication?
What is raid? : SQL Server Architecture
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Explain indexes disadvantages?
what information is maintained within the msdb database? : Sql server administration
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
Explain transaction isolation levels in sql server?
Can we join two tables without primary key?
