Explain error and transaction handling in sql server?

0 Answers  

---

List out the difference between union and union all in sql server?

0 Answers  

---

What is subquery explain with example?

0 Answers  

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---

What is the difference between system objects and user objects?

0 Answers   HCL,

---

---

how many type of indexing in database?

0 Answers   IBM,

---

How to choose all records from the table?

0 Answers  

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

0 Answers  

---

What is sql server programming?

0 Answers  

---

what is dbcc? : Sql server database administration

0 Answers  

---

How to Install SQL SERVER 2005 remotely?

1 Answers   IBM,

---

what is a cursor and what is its use?

2 Answers   L&T,

---