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
- 6136 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 is the difference between Delete and Truncate command in SQL
What are policy management terms?
What is catalog views?
What is temporary table in sql server? Why we use temp table?
Give me any three differences between Truncate and Delete.
what is joins please explain breffly ??
What is the purpose of linked server configuration in sql server?
Call by value and call by reference in procedure and function, with NOCOPY.
What are the differences between char and nchar in ms sql server?
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table
What is tabulation?
-
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)
