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

What are the disadvantages of using the stored procedures?

0 Answers  

---

What is repeatable read?

0 Answers  

---

Explain couple pf features of SQL server

2 Answers  

---

How to execute stored procedure in select statement sql server?

0 Answers  

---

How to populate a table in sql server?

0 Answers  

---

---

What are the disadvantages of indexes?

0 Answers  

---

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 Answers  

---

How to enter unicode character string literals in ms sql server?

0 Answers  

---

Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,

---

What do you understand by the denormalisation?

0 Answers  

---

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---

what is spatial nonclustered index

0 Answers  

---