Do you know hot add cpu in sql server 2008?

0 Answers  

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  

---

What are the different normalization forms?

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,

---

---

Can a database be shrunk with users active?

0 Answers  

---

Explain the cursor lock types?

0 Answers  

---

What is the full form of ddl?

0 Answers  

---

How to create a view on an existing table in ms sql server?

0 Answers  

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

0 Answers  

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

0 Answers  

---

Explain the types of indexes.

0 Answers   Accenture,

---