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
- 6120 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 |
How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)
10 Answers Cognizant, Infosys,
Explain sql server authentication modes?
Tell me about Triggers?
Define right outer join in sql server joins?
How to create function with parameter in sql server?
When is update_statistics command used?
How to use order by with union operators in ms sql server?
What is the meaning of resultset type_scroll_insensitive?
what is the order of execution of where,having,group by in select stement
6 Answers IBM, Tanla Solutions,
Why should one not prefix user stored procedures with ‘sp_’?
What is table-valued sub query?
What is the diff between Dynamic queries and static queries
1 Answers CGG, ICS Integrated Computer Solutions,
-
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)
