We just had an interesting discussion among our team regarding the best way to remove a very large number of rows from a database without having the transaction log grow out of control. The scenario is something like this: Need to delete 50 billion rows from a table Need to do it when there is only 4 G of hard
Similar Posts
I wanted to describe how to add transaction support to your database unit tests. In this previous post I motivate why you would want to do this. It's all
Architecting Service Broker applications (part 2) This is the second in a series on architecting SQL Server 2005 Service Broker (SSB) applications. If
Mars and Transactions MARS (multiple active result-sets) does allow multiple commands to be active on the same connection, however there are some limitations
Compensating Transactions At the Federal Architect Forum a couple weeks ago I was asked when is SQL Server going to have compensating transactions Since
