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 different types of replication in sql server?

0 Answers  

---

What are the properties of primary key?

0 Answers  

---

Explain a join?

0 Answers  

---

how to generate XML out of QUERY?

1 Answers   McAfee,

---

What is normalization?

9 Answers  

---

---

Why I can not enter 0.001 second in date and time literals in ms sql server?

0 Answers  

---

Explain boyce and codd normal form(bcnf)?

0 Answers  

---

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

---

What is sql server profiler?

0 Answers  

---

How to send email from database?

0 Answers  

---

What is difference between stored procedure and user defined function?

0 Answers  

---

What is the advantage of sql server?

0 Answers  

---