What does COMMIT command do?

0 Answers   Amdocs,

---

Explain the various types of concurrency problem?

0 Answers  

---

How can you ensure that the database and sql server based application perform well?

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,

---

Why is the need for data conversion transformations?

0 Answers  

---

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

---

Can two tables share a primary key?

0 Answers  

---

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

0 Answers  

---

Explain table valued parameters in sql server? Why tvp used?

0 Answers  

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

0 Answers  

---

Explain about extended stored procedure?

0 Answers  

---

How do you optimize Sql queries ?

0 Answers   Cognizant,

---