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

List out a number of the wants to setup a SQL Server failover cluster?

1007

---

What is a partition function in sql server?

1023

---

Tell me what is difference between view and materialized view?

882

---

How to disable a login name in ms sql server?

1061

---

Which tcp/ip port does sql server run on? How can it be changed?

976

---

Why I am getting this error when renaming a database in ms sql server?

987

---

Define constraints and give an example of their use?

982

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

1971

---

what types of replication are supported in sql server? : Sql server database administration

954

---

What are drillthrough reports?

141

---

What is the size of transaction log file?

868

---

What are the pre-defined functions in the sql server?

1026

---

What are the tool windows in sql server management studio? : sql server management studio

1015

---

List the different types of joins?

924

---

What is tempdb database? : SQL Server Architecture

1110

---