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

Tell me what are the advantages of using stored procedures?

0 Answers  

---

Do you know what is replace and stuff function in sql server?

0 Answers  

---

What is normalization 1nf 2nf 3nf?

0 Answers  

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  

---

What is rtm version in sql server?

0 Answers  

---

Define synonym?

0 Answers  

---

What's the purpose of Stored Procedure?

6 Answers   Wipro,

---

Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,

---

What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,

---

Data table as parameter in sql server?

0 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

whats new about truncate in sql server 2008?

0 Answers   MedSave Healthcare, Serco,

---