Compatability Changed 80 to 90

• shree

  Say Hey Kid

  Points: 702

  More actions

  March 19, 2009 at 3:15 pm

  #128809

  In my move i have chaged compatability level of database from 80 to 90

  i started heaing from Programmers slow performance .all sp and DTS Packages are running longer and longer.

  for example on the 80 it runs like 1 min on 90 it running like 40 min

  is that some thing happened due to change in compatability.

  thanks in advance.

• Pam Brisjar

  SSChampion

  Points: 12094

  More actions

  March 19, 2009 at 3:24 pm

  #963184

  at minimum, you need to update the statistics. best bet is to rebuild the indexes.