Answer Posted / dharmendra k. dixit

Basically a Transaction is a Series of work..which either
complete successfully or failed in Group.
there is ACID proerty in this
ACID stands for
A - Atomicity
C - Consistancy
I - Isolation
D - Durability

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1116

---

What is master database? : SQL Server Architecture

1083

---

Why we use functions in sql server?

1133

---

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

1050

---

How to create view in stored procedure sql server?

1057

---

How you would rewrite the sql query to return the customerid sorted numerically?

1046

---

how can you check the level of fragmentation on a table? : Sql server administration

1041

---

Explain filtered indexes?

1043

---

Are semicolons required at the end of sql statements in sql server 2005?

1038

---

What stored by the msdb?

1048

---

Differentiate between a local and a global temporary table?

1008

---

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

---

What is index, cluster index and nonclustered index?

1048

---

What is the purpose of grouping data in a report?

1016

---

How do you handle datasets larger than 50 gb?

164

---