SS2K8 vs SS2K5

  • Hi Friends,

    I really crazy to know what is new concepts in Sql Server 2008 which was not in Sql Server 2005.

    Like:--

    1 - Passing Table Parameter in Stored Procedures.

    2 - Compressing Database File Size.

    I am not more towards enhancement

    Like:--

    Date and Time Data type, It was there in Sql 2005 but Combined. And using convert function we can achieve this.

    So I need Minimum of 10 nos. of good reason to upgrade my Database from Sql 2005 to Sql 2008, Like It was present in Sql 2005 to Sql 2000.

    So I mean to say,

    Why should I suggest using Sql Server 2008 Environments to my Clients?

    Cheers!

    Sandy.

    --

  • Hey Sandy,

    Are you getting lazy in your old age? 😉

    Just go over to the MS web site and you'll get all the marketing stuff you need. Here's the page to get you started.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Hey Grant,

    I am only about two two Plus ....(22)+...lolz:P

    Yes, In technology wise, I may not be old like you..lolz..:P

    Thanks Grants, I was expecting your reply....because not having a tech fight from a long days...he he he..lolz;)

    Anyways.. I,ll make a note and try to post here.. as practical difference.

    Cheers!

    Sandy.

    --

  • 22?

    Oh lordy, I knew you were wet behind the ears, but I had no idea. I could be your father... Oh, yuck. No offense, just lamenting my lost youth.

    Anyway, I was mostly kidding about getting lazy. I assume you're looking for opinions.

    I think whether or not you upgrade to 2008 depends on several factors. First, I'd say if you're starting new development any time after August, you should be moving to 2008 just to extend the life of your product's support cycle, not because of any functionality offered by 2008. After that, it's actually hard to make a case for upgrading from 2005 to 2008 unless you need some of the functionality that 2008 offers. For example, I work for an insurance company. A lot of our policy management software just won't take advantage of anything I've seen in 2008. Not that we couldn't put some of it to work, we could, but there's nothing compelling to force the upgrade. However, we also have a set of engineering applications that record our engineers inspections of various sites, buildings, areas, all location specific. We're looking to move to 2008 for these applications because they will take advantage of the new spatial data types and functions in a huge way. Upgrading from 2000 to 2008 is a no-brainer. Support has ended for 2000. Time to move on.

    How's that, not-quite-child-of-mine?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Ok Grant,

    Cool I got it,

    I was kiddin in last post..

    Cheers!

    Sandy.

    --

  • The features that interest me are as follows

    1. Spatial data types

    2. Resource governor

    3. Improvements to SSIS/Analysis Services/reporting Services

    4. Backup compression

    5. Looks good on my CV

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply