Making your T-SQL work smarter for you by having it work as a code generator. Part 1 in a series. Want to save some time writing code? Many DBAs use the trick I'm going to show you this week to: A) ...

I've inherited a large, convoluted project which is suffering from very bad performance problems. I've taken a look at the TSQL and I won't have any problems finding areas to speed up, but it's ...

Microsoft recently updated its All-In-One Script Framework, which features SQL Server (and other) scripts designed to address common problems reported by users in forums, support incidents and online ...

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. In part one of this article, I described a ...