Answer Posted / swetha

There are 2 types of triggers

Insted of trigger:
Instead Of Trigger fires an operation instead of performing
user specified operation.


After trigger: After Trigger fires an operation after any
insert,update,delete operations performed on a table.

Explain the flow of creating a cube? : sql server analysis services, ssas

1037

---

What are the limitations/drawbacks or ssrs 2008 r2?

139

---

What are the transaction properties?

1001

---

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1048

---

How to get a list all databases on the sql server?

1084

---

What is data set in report?

134

---

Explain the etl (extraction, transformation, and loading)?

987

---

What is the openxml statement in sql server?

1057

---

Detail about query optimizer?

1086

---

Where is trigger in sql server?

1031

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

893

---

How would you add a section to a table?

1021

---

Does a full backup include transaction log?

956

---

What is 'Join' and explain its various types.

1127

---

ow to bring suspect mode datbase online from scratch

1799

---