SQL 2008 Vs SQL 2005

  • Hi all, I have a question.

    Is SQL 2008 to SQL 2005 the same as what SQL 2000 was to SQL 7?

    As in, is it the definitive version of a similar product?

    I ask this as I'm planning to devote a considerable amount of time learning one of these products.

    I would like to know if learning SQL 2008 will cover most of SQL 2005.

    Thanks.

  • This is opinion, but no. I'd say 2008 is more of an upgrade than 7 to 2000 was. Not by a lot, but more. However, knowledge learned of 2005 is not going to be wasted on 2008.

    A bigger concern over which to spend time learning is Microsoft's support schedule. 2005 has less life left in it than 2008. If you're just starting development of new systems, I'd automatically start them out in 2008 now. No reason not to (licensing cost, maybe, but I'd start negotiating with MS on that now too).

    "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

  • I'd go with 2008 as well. There were a lot of nice upgrades to SSMS in 2008 and as Grant said, the support life time is growing short for 2005.

Viewing 3 posts - 1 through 3 (of 3 total)

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