Answer Posted / neeraj sharma

When we fire the trigger then the data goes to temporary
tables. when we execute insert, delete, update trigger the
the data goes to temporary tables. these temporary tables
are called as magic tables. There to types of magic tables:
1. Inserted
2. Updated

what method you can use to reduce the overhead of Reporting Services data sources?

268

---

What is parameterized reports in ssrs ?

161

---

What are the rendering extensions of ssrs?

160

---

What is the difference between osql and query analyzer?

1044

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

990

---

What is query optimizer in sql server?

1064

---

application server is slow what may be the problem

2268

---

What are the different types of lock modes in sql server 2000?

992

---

What is a result set object returned by odbc_exec()?

1073

---

How is a full-text index updated?

998

---

What are the differences between sql server and mysql.

1133

---

Explain Capacity planning to create a database? and how to monitor it?

4243

---

what is the sql equivaent of the dataset relation object ?

2068

---

How to use clusters?

1007

---

What are the new features in sql server 2016?

1030

---