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 the different components in replication and what is their use?

0 Answers  

---

List some case manipulation functions in sql?

0 Answers  

---

What is the difference between a function and a stored procedure?

0 Answers  

---

Explain timestamp datatype?

0 Answers  

---

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

0 Answers  

---

---

What is data modeling and Reterminal integrity?

0 Answers  

---

Can group functions be mixed with non-group selection fields in ms sql server?

0 Answers  

---

any one can explain Self mapping Delegation Remote Credentials

1 Answers  

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

---

Explain primary key in sql server?

0 Answers  

---

Find nth lowest salary or get nth lowest salary?

0 Answers  

---