Answer Posted / hari

Transcation is a sequene of operations performaed a single
logical unit of work .it must be excuted acid properties.
Atomicity : set of t-sql statements act as a batch
constitancy : ---
isolation : to reduce the concurrency
durabality : once chages are commied database permentaly
saved

Define self join in sql server joins?

997

---

How to find the list of fixed hard drive and free space on server?

1282

---

what is difference between NULL and ISNULL in SQL Server 2008?

1058

---

What is thr feature of change data capture?

1037

---

Explain about link server in sql server?

1118

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

2054

---

User wants only to display only pdf as export option in report manager. How to achieve this?

269

---

What is a unique index?

974

---

What is the difference between a clustered index and a non-clustered index?

1057

---

What is log cache in sql server?

1100

---

Explain something about security and SQL Azure?

134

---

What is table value parameters (tvp)?

1152

---

How to get the definition of a user defined function back?

1088

---

Describe the functionalities that views support.

1149

---

What is the difference between executequery () and executeupdate ()?

1113

---