Interested to Buy Any Domain ? << Click Here >> for more details...
what is IDE,DMV in sql server?
- 1 Answers
- 8602 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 default value of CHAR type?
Why are sql functions used?
What are the properties and different types of sub-queries?
Differentiate between a having clause and a where clause.
What the different components of Replication and what is their use?
What are relationships and mention different types of relationships in the dbms
Explain atomicity?
Do you have any idea about the tcl commands?
What is built-in/administrator?
Which is the latest version of sql server and when it is released?
How to use union to merge outputs from two queries together in ms sql server?
Can store procedure call by user define function in SQL server?
-
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)
