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

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

What is log cache in sql server?

0 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

---

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

0 Answers  

---

Define cross join in sql server joins?

0 Answers  

---

Can we insert data into a view?

0 Answers  

---

What are built in functions?

0 Answers  

---

What is a stored procedure?

3 Answers  

---

Is mysql better than sql server?

0 Answers  

---

Explain transaction isolation levels in sql server?

0 Answers  

---

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

---

What is function of ROLLUP ?

0 Answers   HCL,

---