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 different types of backup avaible in SQL SErver

6 Answers   Emphasis, IBM,

---

Can you explain full-text query in sql server?

0 Answers  

---

What is identity?

0 Answers  

---

what is raid? : Sql server database administration

0 Answers  

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

0 Answers  

---

---

What is 2nf normalization form?

0 Answers  

---

what is the difference between Delete and Truncate

4 Answers   CarrizalSoft Technologies, Geo Research Centre,

---

Is mysql better than sql server?

0 Answers  

---

What is difference between group by and having?

0 Answers  

---

Where are sql server user names and passwords stored in sql server?

0 Answers  

---

when would you go for denormalization? : Sql server database administration

0 Answers  

---

What will you do If the low Performance occurs?

2 Answers  

---