What is raid, and how it can influence database performance?

0 Answers  

---

What is the purpose of using COLLATE in a query?

1 Answers  

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

0 Answers  

---

How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  

---

What is Peer to peer Replication?

1 Answers   CarrizalSoft Technologies, HCL,

---

Describe in brief system database.

0 Answers  

---

What is coalesce in sql server?

0 Answers  

---

What is sparse columns of sql server 2008?

0 Answers  

---

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   CarrizalSoft Technologies, L&T,

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

0 Answers   ABC,

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers   HCL,

---