Date Conversions

Deleting Large Number of Records

Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005

Entering the Dark Side

If any of you follow me on SQLServerCentral.com, then you know I recently started a new job.  Well, after two...

Sins of a Recursive CTE?

On June 1, 2010, Steve Gray had an article, Sins of SQL: The Time Table, published on sqlservercentral.com.  I’m not...

Backups

Getting Scared

This is not a technical post, it’s personal, but I need to express my fears.  It isn’t about our economy,...

The Dynamic Tally or Numbers Table

Building a tally table is a common T-SQL problem that many new developers struggle with. Lynn Pettis brings us an article that shows how to use CTEs to accomplish this.

My next republished article is now available

Okay, my second article which was originally published on sswug.org, is now available on SQLServerCentral.com.  This article compares two methods...

Republished Article

Well, the first of two articles I originally had published on sswug.org will be published on ssc tomorrow.  I'm looking...

Welcome Home !!

I realize I have been relatively quiet for a while, but summer is actually a fairly busy time for us...