Answer / Sudhanshu Shekhar

In SQL Server, you can use the sp_who2 stored procedure to view current processes. It returns information about active sessions and their related resources:

```sql
EXEC sp_who2

What causes index fragmentation?

1 Answers  

---

New concepts of sql server 2005 use in your project.

1 Answers   TCS,

---

What is the purpose of floor function?

1 Answers  

---

Why I am getting this error when dropping a database in ms sql server?

1 Answers  

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

1 Answers  

---

What are the different types of stored procedures?

1 Answers  

---

Equi join and non equi join is possible with sql server?

0 Answers  

---

What is a data source or ds? : sql server analysis services, ssas

1 Answers  

---

what is a correlated sub-query? : Sql server database administration

1 Answers  

---

What do you understand by recursive stored procedures?

1 Answers  

---

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

---

Explain syntax for disabling triggers?

1 Answers  

---