Information générale
Forum:
Microsoft SQL Server
Hello Michael,
Thanks for your help, we tryied removing the cursor and other alternatives and still got the problem.
We found a quick fix by changing the compatibility level of the database from 80 to 70 (going back to SQL 7 compatibility) and a big surprise happened, our query executed in 42 seconds !!!
We really don't understand what's going on, and we think about placing a call with MS.
Thanks,
ERic.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement