How cand Optimize SQL Server Stored Procedures

1 Answers  

---

What is Cross Join and in which scenario do we use Cross Join?

0 Answers   QuestPond,

---

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

---

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

---

What is meant by referential integrity?

0 Answers   Blue Star,

---

Is it true, that there is no difference between a rule and a check constraint?

0 Answers  

---

What is 2nf normalization form?

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  

---

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

---

What is a raid and what are different types of raid configurations?

0 Answers  

---

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,

---

What is repeatable read?

0 Answers  

---