Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimizing deletion in batch
Message
De
31/12/2013 13:52:19
 
 
À
31/12/2013 13:48:26
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01591061
Message ID:
01591192
Vues:
48
OK, thanks....two questions right away

1) I'm assuming that Numero is some kind of identity/sequentially assigned value, and that the rows you're trying to delete will ALWAYS have a numero value that is less than the numero that's being assigned on the insert

2) Are there insert/update/delete triggers on the Hit table that you're inserting/deleting?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform