This has been submitted.

I would like to write this up.

@Blob_Eater: We left it at that moment because the issue was in our production system. We wanted to make controlled changes and monitor what the result was. There...

I'll write one up for this, Steve. Wrapping up my linked server piece this week then I'll get started on this.

I will take a stab at this if it is still available.

I have sent a PM with the article.

I would like to write an article for this. I recently had to address a real world issue regarding latching and blocking that was caused by parallelism resulting from...

I would go with a simple recursive statement.

DECLARE @dateone AS DATE = '2012-01-01'

DECLARE @datetwo AS DATE = '2015-04-12'

;WITH cte AS (

SELECT 1 AS month_

UNION ALL

SELECT 1+ month_

FROM...