What are the new features in SQL Server 2005?
- 3 Answers
- 5999 Views
- Emphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / hari
Management Studio
DMV
CLR Interegation
Database mirroring
| Is This Answer Correct ? | 3 Yes | 0 No |
- 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/
| Is This Answer Correct ? | 0 Yes | 0 No |
How to enter unicode character string literals in ms sql server?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
How to write a query with a full outer join in ms sql server?
What is a trigger in sql server?
What is the difference between indexing and hashing?
What is temporary table in sql server? Why we use temp table?
What is partition in sql server?
What command do we use to rename a db, a table and a column?
What is trace flag in sql server?
How to assign new column names in a view?
How to assign null values to variables or columns?
what are different types of raid configurations? : Sql server database administration
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
