Interested to Buy Any Domain ? << Click Here >> for more details...
What are the new features in SQL Server 2005?
- 3 Answers
- 6929 Views
- Emphasis, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to add the custom code in Report?
What are the disadvantages of indexes?
what is the sql equivaent of the dataset relation object ?
Do you know concepts and capabilities of sql server?
What will happen if a column containing char type data is changed to the nchar data type?
What are different types of views?
Explain different types of locks in sql server.
What are the types of resultset?
What are the restraints imposed on the table design by a merge replication?
What is CTE in SQL
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Which is faster statement or preparedstatement?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What is the usage of the sign function?
