Answer Posted / 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 backups avaialabe in sql server 2005?

969

---

What is the sql server 2000 version number?

1007

---

Explain what you mean by 3 tier architecture.

1017

---

Where cross join is used?

903

---

How many types of objects are there?

934

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

1971

---

What is the purpose of data source?

954

---

What happens if we shrink log file in sql server?

909

---

What is RAID? What are the different types of RAID configurations?

1062

---

How would you go about developing a ssrs report?

158

---

Describe in brief authentication modes in sql server.

966

---

What is database dimension? : sql server analysis services, ssas

1031

---

Show Practically Sql Server Views are updatable?

1054

---

How do I run a trace in sql server?

928

---

Why do we use stored procedures in sql server?

894

---