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

Write query to return all rows sql?

0 Answers  

---

What happens to a trigger with multiple affected rows?

0 Answers  

---

What is Outter Join?

1 Answers  

---

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

0 Answers  

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

How will you decide the active and passive nodes?

0 Answers  

---

How to find out the list schema name and table name for the database?

0 Answers  

---

I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 Answers  

---

Do you know what guidelines should be followed to help minimize deadlocks?

0 Answers  

---

Differentiate between a primary key and a unique key.

0 Answers  

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

0 Answers  

---

Do you know exporting and importing utility?

0 Answers  

---