Answer Posted / rajkumar v

SQLserver2000
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.

SQLserver2005

3 types:

1. DML,
2. DDL &
3. CLR

How do you improve the performance of a SQL Azure Database?

137

---

What is page-level compression?

949

---

How many databases can we create in a single server?

207

---

List types of tables in SQL Azure?

126

---

What is surrogate key? : sql server analysis services, ssas

1100

---

What is rank function?

1018

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

986

---

Explain how does the report manager work in ssrs?

948

---

What is multilevel indexing?

922

---

What are the basic functions for master, msdb, model, tempdb databases?

1030

---

Explain the difference between function and stored procedure?

930

---

How do you create a clustered index?

1042

---

What is a livelock?

949

---

Explain in brief how sql server enhances scalability of the database system?

971

---

What is 3nf normalization form?

1099

---