Browse by Tags

Quick and Simple Deletes
06 May 11 06:45 PM | MartinCroft | with no comments

Day 6 and a Friday so keep it simple. There are occasions where you want to delete a huge table and truncation is just not an option for various reasons, but deleting from the table creates a huge transaction log. You don’t want to over engineer the solution...

Filed under: SQL 2008, @@ROWCOUNT, SQL2008, DELETE