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
- 6127 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 do you understand by physical_only option in dbcc checkdb?
Explain what is lock escalation and what is its purpose?
How to connect php with different port numbers?
What is clustered primary key?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
How to select top 5 coloumn from a table without using coloumn name
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is the purpose of object explorer and its features? : sql server management studio
How do you make a trace?
-
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)
