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
- 6035 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 |
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What are the benefits of using stored procedures over sql statements?
user defined datatypes
If no size is defined while creating the database, what size will the database have?
Does a full backup include transaction log?
what is DTS what are tasks available
can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com
How can I get data from a database on another server?
How you can move data or databases between servers and databases in sql server?
Which are the olap features?
explain how to create a new schema in a database? : Sql server database administration
-
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)
