Interested to Buy Any Domain ? << Click Here >> for more details...
what is IDE,DMV in sql server?
- 1 Answers
- 8698 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer / neeraj malik
Dynamic management views and functions return server state
information that can be used to monitor the health of a
server instance, diagnose problems, and tune performance.
Example:
sys.dm_db_index_physical_stat gives u stats and
fragmentatin information for the specified index.
sys.dm_db_operational_stat gives information abt latches,
and locks on given index.
Best
Neeraj Malik
| Is This Answer Correct ? | 6 Yes | 1 No |
What is the SQL?????????????????????????????
How do you rebuild an identity column?
How to connect ms access to sql servers through odbc?
what is Archive old data?
Can coalesce return null?
Tell me the phases a transaction has to undergo?
Do you know the capabilities of cursors?
hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?
7 Answers Google, TCS, Unisys,
What is compound operators?
What is the dbcc command and why is it used?
What are pages and extents? : SQL Server Architecture
What is bit data type? What's the information that can be stored inside a bit column?
-
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)
