In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.

There are times as a developer that you will want to be able to delete all the data from a database as efficiently as possible. Unfortunately, doing so may not be as easy as it seems.

We've got a table used to log operations that gets it's data aggregated and then all it's rows deleted nightly, which I'm trying to speed up as much as possible. I think that deleting the rows is ...

But there are other lessons in this announcement that CIOs and CTOs seeking to make Hadoop work in their businesses would do well to pay attention to. Real SQL Matters While much of the emphasis ...