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
- 6016 Views
- TCS, I also Faced
- E-Mail Answers
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 are the advantages of using a stored procedure?
What is oltp (online transaction processing)?
what is performance tunning in sql server ? explain.
Where are full-text indexes stored?
Does a sql server 2005 select statement require a from?
how to get 25th row in any table in sqlserver can u tell me syntax
What is the correct order of the logical query processing phases?
What is normalization according to you and explain its different levels?
Can I save my report as html, excel or word? : sql server management studio
Explain in brief how sql server enhances scalability of the database system?
Explain error handling in ssis?
What is difference between inner join and join?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
