how to improve the speed of SQL database server and how to
avoid dead lock?
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)