SQL Server 2012 Service Pack 1 Cumulative Update #2 is available!
The SQL Server team has released CU #2 for Service Pack 1, which should include all of the fixes from CU #5, as well as some others. KB article: KB #2790947 Build # is...
The SQL Server team has released CU #2 for Service Pack 1, which should include all of the fixes from CU #5, as well as some others. KB article: KB #2790947 Build # is...
Today Microsoft has released a new cumulative update for SQL Server 2008 SP3. KB article: KB #2799883 There are three fixes listed at the time of writing The build number is 10.00.5829.00 Relevant for...
In part 3, I shift focus to generating sequences of dates.
In this installment, I talk about the next level of scale: generating sets of 50,000 and 1,000,000 numbers.
I discuss ways to generate a contiguous set of numbers from 1 to 1,000.
I talk about some potential inefficiencies here that you might not notice on low volume sites but that will start to affect performance as your web volume ramps up.