Answer Posted / skumar

There are many features introduced.
1. XML data type
2. Synonym
3. Instead of Trigger on indexed views
4. CROSS APPLY
5. INTERSECT and EXCEPT statements
6. CTE (Common Table Expressions)
7. PIVOT and UNPIVOT
8. TRY...CATCH and RAISERROR
9. .NET CLR integration
10. Custom data types
11. New data types like NTEXT,NVARCHAR,NCHAR
12.64 bit platform
13.DDL Triggers
14. New functions like RANK(),DENSE_RANK() and ROW_NUMBER
15. MAX Keyword
16. Table variable

What is TDS(Tabular Data Stream) Gateway?

99

---

Which joins are sql server default?

506

---

Explain how to maintain a fill factor in existing indexes?

525

---

What is the difference between varchar and nvarchar datatypes?

569

---

What the different topologies in which replication can be configured?

556

---

---

what is denormalization and when would you go for it? : Sql server database administration

699

---

What is a full text index?

492

---

How do I delete a sql server database?

543

---

Explain the truncate command? : SQL Server Architecture

562

---

What are the advantages of partitioning?

638

---

What is a trigger in sql server?

530

---

Delete duplicate rows without using rowid.

1066

---

What is the difference between varchar and varchar types?

562

---

What is dbcc updateusage?

534

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

528

---