opbang

 Profile Answers by opbang 

• Sep 23rd, 2006

 

SQL Server 2005 is having much more functionality than SQL Server 2000

SQL Server 2005 is having Integrated SQL Server Management Studio which combines Enterprise Manager, Query Analyser and lot More

SQL 2005 integrated very well with Visual Studio and dot net.

The DTS of SQL 2000 has been replaced with SSIS (Sql Server Integrated
Services). It is completely new and ready to compete with Other ETL Vendors.

BI Studio is having SSIS - SQL Server Intergraion Services,  SSAS - SQL Server Analysis Services, SSRS - SQL Server Reporting Services and Notification Services.

It is having complete suit to build DWH.  It is having end to end solution for DW/BI

 

 

 

 

hemant

• Oct 17th, 2006

 

There are various new features in SQL 2005

1. SQLCLR - Microsoft has come up with CLS for SQL server which would enable SPs, functions, triggers to be available in TRULY compiled state and the resultant MSIL assemblies can be used as a deployment unit, which would then be JIT compiled prior execution.
2. Configuration is dynamic - Configurations made to SQL 2005 database would reflect realtime without having to restart the server.
3. XML datatype - Built in support for native XML datatype. With this new datatype
4. Recursive queries - Common table Expressions (CTEs) enables queries to be recursive in nature.
5. SQL Server Management Object - Object based management framework lets one create custom applications for Server management. SMOs provide object hierarchy at run time thereby letting you instantiate objects for Server, tables, columns,

nandakishore

• Oct 18th, 2006

 

There are lot of independent and powerful features have been implemented in SQL Server 2005,Some of these features are avaiable in other databases but some are specific for SQL Server for example

Database Partitions (all ready available in other Db's)

Service Broker: Enables developers to transmit messages using this at database level. This will help in deveoping applications which are similar use like MSMQ

CLR : Another new feature enables SQL developers to write code in C# or VB.NET instead of PL/SQL. Advantage of this is we can avoid using cursors

DB Mirroring: Failover is now not a problem

XML datatype & much more new features which gives alltogether a powerful weapon to deal with db's

Ranjit

 Profile Answers by Ranjit 

• Dec 6th, 2006

 

Here is the Top 30 features of Sql 2005

http://www.microsoft.com/sql/prodinfo/features/top30features.mspx