Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SP takes longer than batch version
Message
 
À
27/01/2006 16:54:36
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01090888
Message ID:
01091100
Vues:
22
Not a problem... thanks for trying...


>>Yep, it said to take nearly all the indexes off (except the primary). That put me back at the 2:30 mark. I placed the index that we've been talking about and the batch at least works as I said.
>>
>>Something just ain't right...
>>
>>Richard
>>
>
>Richard,
>to words I would not know what other to tell you, would need to hold the database.
>
>It could be also a bug of the optimizer.
>
>Hi.
>
>Fabio
State of Florida, DCF
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform