SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Published, Again!

I have written two new articles and they are going to be published, not on SSC but on SSWUG.  I thought I'd help out Chris Shaw a bit and write a few articles for him as well.  Plus it broadens my horizons some as well.

The first article, based on numerous posts here on SSC is titled Deleting Numerous Rows from a Table, and will be published on May 25th.  It shows how to delete records in batches and control the size of the transaction log files, if the database is using the bulk logged or full recovery model.  This article originally started as my first blog entry, but when I finished it, it seemed more like an article.

The second article, to be published on June 1st, is titled The Dynamic Tally or Numbers Table.  I wrote this one after reading an article in SQL Server Magazine about creating a tally table.  I think you will find the methodology behind my dynamic tally table much more performant than the one in the SQL Server Magazine article.


Posted by RBarryYoung on 2 May 2009

Congratulations, Lynn!  Let me know when they are going to appear.

Posted by Dugi on 4 May 2009

It seems very nice articles, but why not also in SSC!? The second one seems very nice and I want to see what we can do more with Tally Table!

Posted by Lynn Pettis on 4 May 2009

As I mentioned in my blog I decided to expand my horizons a bit and help out a friend by writing a few articles for him and SSWUG.  Perhaps Steve could link to the article on SSWUG when it is published, but I can't submit it to Steve to be published directly on SSC until mid to late August.  I have to wait 120 days from submitting the article to SSWUG before I can have it published somewhere else.

Posted by Steve Jones on 4 May 2009


Leave a Comment

Please register or log in to leave a comment.