SQL server 2008 features/benefits?

Question

Duplicate of:

• known and “unknown” incompatibilities between sql 2005 and 2008?
• SQL Server 2005 vs SQL Server 2008 [closed]
• Advantages of MS SQL Server 2008 over MS SQL Server 2005?

And many more.

---

Hi

I have been using SQL server 2000 for a few years but now have access to SQL server 2008 for development.

Apart from the obvious things like the new management studio and intellisense what are the main features and benefits of SQL server 2008?

What is the general consensus on the performance of the management studio compared to the out dated SQL 2000 enterprise manager and query analyzer applications?

Thanks

Answer 1

Check out this question. Granted the title is for advantages of 2008 over 2005, I think the feature list is quite comprehensive and will show you all that 2000 isn't offering.

SQL Server Management Studio is a lot nicer than Enterprise Manager. It is a little different since SSMS uses more of a Visual Studio interface. But there are lot more features in SSMS easily available.