What stored procedure can you use to display the current processes?

0 Answers  

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers  

---

Explain difference between cross join and full outer join?

0 Answers  

---

How to automatically create a log when an exception is being received into SQL Server?

0 Answers   Cap Gemini,

---

---

What is use of @@ spid in sql server?

0 Answers  

---

Explain identity in sql server?

0 Answers  

---

Explain Normalization and DE normalization

0 Answers   iNautix,

---

What is the fillfactor concept in indexes?

0 Answers  

---

what is hash table

3 Answers   ILFS, Teledata,

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

how to change column into row in sql

4 Answers   ESS,

---