Benefits of SQL Server 2005 2000

Question

Can someone please name a few. I could give time, but this is for someone else, and I would also like some input to the community.

Answer 1

Some differences:

• CLR stored procedures (.NET)
• SSIS instead of DTS
• Management Studio instead of Enterprise Manager, with more features (version 2008 is even better)
• VS integration
• best replication
• SMO and AMO (extensions for processing a server from applications)
• partitioning tables and indexes
• XML as a data type
• XQuery for handling XML data type
• Service broker
• Notification Services
• Analysis Services
• Report Service

. , .

Answer 2

, TSQL. .

Answer 3

:

1 - XML.

2 - . - , .

Answer 4

.

Answer 5

varchar (MAX)

SQL Server 2000 SQL Server 7 8000 ... , Microsoft VARCHAR (MAX), NVARCHAR (MAX) VARBINARY (MAX) SQL Server 2005. BLOB (2 ), . MAX 8 , .

http://www.teratrax.com/articles/varchar_max.html

Answer 6

CLR

Answer 7

/

Answer 8

. , 2000 , , .

Answer 9

- - TRY CATCH - SQL2005 , SQL2000 .

:

BEGIN TRY
    -- Generate divide-by-zero error.
    SELECT 1/0;
END TRY
BEGIN CATCH
    -- Execute custom error retrieval routine.
END CATCH;

Answer 10

, . SQL Server 2000 Analysis Services Reporting. - , , . , , SQL Express, 2005 , / .

Answer 11

SQL Express has a larger database size than the previous MSDE product (4Gb vs 2Gb), so it’s great, as Slavo said for testing and small applications. SQL Server 2005 is updated through Microsoft Update, which is good or bad depending on your point of view.

Answer 12

PIVOT / UNPIVOT operators have become a big victory for me.

PIVOT rotates row-based output into columns, which is a huge help for many of our reporting needs. We had to collapse our own functions for PIVOT before SQL 2005.