Answer / Deependra Kumar

{"tracing traffic": "To trace the traffic hitting a SQL Server, you can use the SQL Profiler tool or Extended Events. These tools help capture data about network traffic, SQL statements executed, and other performance-related information. You can filter events based on conditions to focus on specific types of network activity."}

what operator performs pattern matching?

2 Answers  

---

how we can store the value like that 001,003,023 etc in sql server 2005

7 Answers  

---

How to Get the last identity value used

4 Answers  

---

How many types of cursors are there in SQL Server?

5 Answers   247Customer, CarrizalSoft Technologies,

---

What is an identity column in insert statements?

1 Answers  

---

What is read committed?

1 Answers  

---

What is forward - only cursors / read only cursor?

1 Answers  

---

What are key constraints?

1 Answers  

---

Differentiate between sql temp table vs table variable?

1 Answers  

---

plz send every query in sql server2000

1 Answers   Infosys,

---

Explain different types of index?

1 Answers  

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

1 Answers  

---