How to download and install the scaled-down database adventureworkslt?

0 Answers  

---

What is a transaction and what are ACID properties?

14 Answers   Config Systems, IBM, TCS, Virtusa,

---

what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,

---

What is scrollable cursor?

0 Answers  

---

How to drop an existing stored procedure in ms sql server?

0 Answers  

---

---

Mention the different types of triggers?

0 Answers  

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  

---

Can two tables share a primary key?

0 Answers  

---

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---

Is there any difference between primary key and unique with the not null condition?

0 Answers  

---

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

---

Write a SQL query in order to merge two different columns into single column?

0 Answers   QuestPond,

---