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 is open database communication (odbc)?

0 Answers  

---

What is unique key constraint?

0 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

Explain index in sql server?

0 Answers  

---

what are batch in sql server?

2 Answers   Satyam,

---

what is Equity join?

2 Answers   ADP,

---

How to use user defined functions in expressions?

0 Answers  

---

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

0 Answers  

---

What are the indexes in sql server?

0 Answers  

---

What are three major types of constraints?

0 Answers  

---

how many type of subquery?

2 Answers  

---

What are constraints in microsoft sql server?

0 Answers  

---