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
- 6032 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 can we improve performance by using SQL Server profiler?
what is the difference between count(*) and count(1) ?
What happens if ntwdblib.dll is missing on your machine?
How many instances per computer are there in sql server 2000?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
please tell me the query to get details of the employee having the second largest salary
What are the database roles? : sql server security
Explain the relational database management system (rdbms)?
What is SQL Server?
Do you know what are acid properties of transaction?
What is Transparent Data Encryption?
-
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)
