Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2014
The real question - besides simplifying code - is whether keeping the old records in their place on disk will minimize access time (for old HDs, mostly head movement) or wear level (for heavily used SSDs). As indexing strategy (including PK generation) plays a role, difficult to say IMO, if not premature optimization. OTOH, if the code is long enough in use it should be bug free, so eliminating will reduce the amount of code worked upon only minimally.
>SQL Server does not keep deleted records like VFP does. If you delete a row, it is removed by SQL Server. Recycling records is something that isn't done in SQL Server.
>
>
>>I know; I was not using RECALL (in VFP). I am setting a certain field value to 'D' and then look for these records (with 'D') and set the value back to empty. So my recycling (in VFP) is not Delete/Recall. So I could, in theory, apply it to SQL Server. But I am trying to simplify my code; hence this question.
>>Thank you.
Précédent
Suivant
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