SQL Server 2000 vs SQL Server 2005
-
This was removed by the editor as SPAM
-
Major difference between 2000 & 2005 is the integration of the .NET CLR, in my opinion. Although this is geared towards developers, you might check out the book, "A First Look at Microsoft SQL Server 2005 for Developers":
There's a lot of information in that book, and it really covers a lot of the perspective and goals from Microsoft when they were designing Yukon.
-
In addition, Support is being dropped for some of the OLD protocals in SQL 2005; the one I am aware of is DB-LIB support.
Tim S
-
There's a lot of new enhancements to T-SQL, including Common Table Expressions (or recursive queries), pivoting, partitioning, database snapshots, online indexing. Huge improvements in xml data, including XQuery to search inside xml data, and xml indexes.
There's also better integrated full-text searching, Notification Services, Service Broker (replaced MSMQ), SQLiMail (so you dont need Outlook for email anymore), Integration Services (formerly DTS), Reporting Services, Analysis Services.
And of course the most talked about feature, CLR / .Net integration
There's really just too much to list. I've been working with SQL Server 2005 for the last 8 months, and it's really exciting. Seriously, get you hands on the latest CTP Release, install and play with it. Once you get used to it, you'll find all the features you were missing in 2000 and you'll never look back.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql_ovyukondev.asp
Julian Kuiters
juliankuiters.id.au -
Thats a great information, thanks alot Julian
Ezz Khayyat
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply