Browse by Tags

Merge–under used statement
07 May 11 04:54 PM | MartinCroft | 1 comment(s)
Day 7. The MERGE statement is one that quite a few DBA are aware of and use but is under used by developers. I think because they are not aware of all the scenarios that it can be used in. I recently had a variety of scenarios that developers had asked...
Filed under: , , ,
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...