Answer Posted / ashique

Transaction is a database operation that satisfies following
a condition called ACID:

A (Atomicity) : Do all the operations successfully Or None.
C (Consistency) : The operation should not violate data
integrity concept.
I (Isolation) : When one person is manipulating the data,
others should wait (i.e synchronization).
D (Durability): Once transaction is over succesfully, the
changes should be permanent at any cost.

The best example of a simple transaction is bank fund
transfer from one account to another. Try to implement above
points using your common sense. Thank you :)

What is extended stored procedures?

966

---

Which are new data types introduced in sql server 2008?

1050

---

Do you know the isolation level that sql server support?

961

---

What is tablix?

162

---

Why olap is used?

974

---

what happens on checkpoint? : Sql server database administration

1103

---

Why use update_statistics command in sql server?

1058

---

what are different types of backups available in sql server? : Sql server database administration

938

---

What command do we use to rename a db, a table and a column?

927

---

Explain concepts of analysis services?

963

---

What is the difference between Stored Procedures and triggers?

1082

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1010

---

What does the not null constraint do?

1089

---

What is a benefit of using an after insert trigger over using a before insert trigger?

986

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1017

---