Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
An esoteric little SQL brain teaser
Message
De
21/10/2013 13:25:58
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2012
Application:
Web
Divers
Thread ID:
01585872
Message ID:
01585970
Vues:
41
That's a good point about why would anyone want to truncate a table within a transaction to begin with.

It's not likely - and like I said at the outset, it's quite esoteric and not in the mainstream.

More than anything else, it's information about what SQL Server tracks in the txaction log.

The path of learning has many forks in the road, and one little path is debunking myths. SQL Server certainly has a few myths - this is one of them, correlated subqueries is another, table variables always being faster than temp tables another, etc.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform