Best approaches for grouped running totals
I follow up on a running totals post with an article describing different ways to achieve the same types of results for more complex grouping and aggregation.
I follow up on a running totals post with an article describing different ways to achieve the same types of results for more complex grouping and aggregation.
After a discussion with a colleague, I take a look at the IDENT_CURRENT() function, and demonstrate how it cannot be relied upon for reporting the IDENTITY value that was generated, even under SERIALIZABLE.
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update #15 Build # 10.00.5850 KB Article: KB #2923520 3 public fixes (4 total) Relevant for builds 10.00.5500 -> 10.00.5849 NOT for SQL Server...
The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #8. KB Article: KB #2917531 Build # is 11.0.3401 Currently there are 32 public fixes (34 total); the most interesting to me...
I talk a little more about in-memory table-valued parameters, and explains why some scenarios you test may not demonstrate the power of this technology.
I explained how I justified purchasing a new Mac Pro, and show that it is very tough to order a comparable PC at similar price points.