how to improve the speed of SQL database server and how to
avoid dead lock?
- 1 Answers
- 5667 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 |
Does full backup break log chain?
Explain the concept of recursive stored procedure.
How do you identify a foreign key?
what is the disadvantage of SQL Loder?
How many types of built in functions are there in sql server 2012?
What is logon trigger?
What is data source object?
Distinguish between commit and rollback?
What is view in sql?
any one can explain Self mapping Delegation Remote Credentials
What are the types of backup and tell me the difference between full and differential backup?
What is sql server profiler?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
