Post reply

T-SQL Gotchas When Upgrading From SS 2000 to 2005?

  • September 17, 2009 at 12:18 pm

    #135716

    Apologies if this is covered elsewhere -- my searches weren't successful.

    The SQL Server behind my company's ERP system was recently upgraded from SQL Server 2000 to SS 2005. I am sometimes asked to write or troubleshoot queries that run in that database. In most cases, our old SQL code runs fine in SS 2005, and often runs significantly faster. Not always, though. Some scripts hang or are dramatically slower. So, will someone please direct me to a discussion or book (or whatever) that explains why previously functional SQL code might fail or perform poorly after an upgrade to SS 2005?

    Thanks in advance...

    -- Brad

  • September 17, 2009 at 1:20 pm

    #1055231

    There are multiple reasons, but often it's a different execution plan than you expect, and that can be because of statistics being out of date. I usually look to check on statistics or indexes after upgrading.

    Here are a few discussions:

    http://www.sqlservercentral.com/Forums/Topic476887-146-1.aspx

    http://www.sqlservercentral.com/Forums/Topic778825-360-1.aspx

  • September 17, 2009 at 4:53 pm

    #1055297

    I'll talk to the dba who did the upgrade and see if we might have old statistics.

    Thank you!

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

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