Answer / dinesh

• .NET Common Language Runtime integration: This
means you can write stored procedures, functions, triggers,
user-defined types, and even new aggregates in any .NET
language.
• Native HTTP SOAP Access: This means that the
database server can serve up data via Web Services with no
additional middleware at all, not even an instance of IIS.
• New xml data type: You can store XML data natively
in its own column type now.
• XQuery support: SQL Server supports XQuery for
querying against XML data, including extensions that allow
XML DDL operations.
• Improved Error Handling: T-SQL now supports TRY-
CATCH blocks for modern error handling.
• DDL Triggers: You can set up triggers that fire
when CREATE, ALTER, or DROP statements are executed.
• Query Notifications: With query notifications, an
external application can request the database engine to
notify it when the data in a cached result set changes.
This can dramatically lessen the load from requerying.
• Failover clustering now extends to 8 nodes on 32-
bit systems, and 4 nodes on 64-bit systems.
• Database mirroring introduces a new reliability
model for hot standby on a database-by-database basis.
• Users now have acess to a database during a restore
operation, within certain limits. This helps get you up and
running faster after problems.
• Multiple Active Result Sets (MARS): SQL Server 2005
introduces the ability for multiple statements to return
result sets at the same time on a single connection.

Answer / hari

Management Studio
DMV
CLR Interegation
Database mirroring

Answer / manub22

- CTE
- APPLY OPERATOR (CROSS, OUTER)
- OVER CLAUSE with PARTITION BY
- RANKING FUNCTIONS
- PIVOT & UNPIVOT
- Synonyms

Check here all new features in SQL Server 2005: http://sqlwithmanoj.com/category/sql-server-versions/sql-server-2005-sql-server-versions/

What is difference between inner join and full join?

0 Answers  

---

What is the boxing and unboxing concept in .net?

0 Answers  

---

what operator performs pattern matching?

2 Answers  

---

How to disable stored procedure sql server?

0 Answers  

---

What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,

---

What are distributed partitioned views?

0 Answers  

---

Difference between DELETE and TRUNCATE?

0 Answers   TCS,

---

What is lock escalation?

1 Answers  

---

How do I start sql server agent automatically?

0 Answers  

---

List all types of constraints in sql server?

0 Answers  

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

0 Answers  

---