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
- 6190 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 4nf in normalization form?
how can a database be repaired? : Sql server administration
Can you pass expressions to function parameters?
What is the difference between inner join and equi join?
How to a Query to copy data from on table to another table.
Can we return Data from 4(more than 1) tables in stored procedure?
How to trouble shoot if unable to connect SQL Server
What is data compression?
What is difference between clustered index and non clustered index?
List out the different types of locks available in sql server?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What is rank function?
-
Oracle (3253) - 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)
