Description: A meeting place for people passionate about Data Warehouse and Business Intelligence
general (2959) data warehouse best practices (1) data warehouse dictionary (1)
Data Warehouse Best Practices
Together we've discovered in Custom Row Versioning - Part 1 what were the main challenges we were facing in order to address the very hot topic of the concurrent data access. Now we will focus on the technical solution that we've implemented for SQL Server 2008 R2 Database Engine. However, as you will see, the solution is pretty straight forward and a similar approach could be applied under different database engines.
What I've realized while working on this data concurrency problem is that the final solution will involve a Row Versioning solution that would have to work with Partition Switch approach. This meant that we should be able to handle any INSERT/UPDATE/DELETE operations that would be reflected in the final table, as a result of the table Partition Switch, without: