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 is sub query and its properties?

964

---

Explain what is row_number function?

1004

---

What is SubQuery in SQL Server 2008

1006

---

What are different types of raid configurations? : SQL Server Architecture

1054

---

How does recursive cte works in sql server?

986

---

What is meant by indexing files?

1024

---

What is the use of sign function?

1093

---

How important do you consider cursors or while loops for a transactional database?

947

---

How do you clear a log file?

1031

---

Difference between report and query parameter. Why do we need different type of parameter?

932

---

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1019

---

Which trace flags are enabled in sql server?

989

---

Can group by and orderby be used together?

995

---

Explain what is dbcc?

995

---

List the various tools available for performance tuning?

874

---