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 a data collection table?

0 Answers  

---

Why do we need different type of parameter?

0 Answers  

---

How to create a user name in a database?

0 Answers  

---

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

---

write the query for taking database restore in sql?

2 Answers  

---

---

What is sub-query in sql server? Explain its properties.

0 Answers  

---

What are the kinds of subquery?

0 Answers  

---

What is the difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  

---

How to disable triggers using "disable trigger"?

0 Answers  

---

Diff. b/w Full Outer Join And Cross Join?

3 Answers  

---

How to select an exiting database using mssql_select_db()?

0 Answers  

---