Answer / Anand Kumar Sonker

In SQL Server context, ACID stands for Atomicity, Consistency, Isolation, and Durability. These properties ensure that database transactions are processed reliably.nAtomicity: A transaction is a logical group of operations. If one operation fails, the entire transaction should fail.nConsistency: A transaction should bring the database from one valid state to another.nIsolation: Concurrent execution of transactions should not interfere with each other.nDurability: Once committed, a transaction must remain committed even in case of power failure or system crashes.

Explain the different types of backups available in sql server? : sql server database administration

1 Answers  

---

What are the joins in sql server? : sql server database administration

1 Answers  

---

What is the purpose of object explorer and its features? : sql server management studio

1 Answers  

---

How to execute a sql statement using mssql_query()?

1 Answers  

---

What is the default fill factor value?

1 Answers  

---

query processing

1 Answers  

---

Does a server store data?

1 Answers  

---

What is the difference between resultset and resultsetmetadata?

1 Answers  

---

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

---

Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

1 Answers   United Healthcare,

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

Explain Geometry datatype in sql server 2008 with example

1 Answers   Infosys,

---