Inserting into Large Parent Child DimensionsIn this post I’m implementing another of John Welch’s patterns from his SQLBits session on Handling Advanced Data Warehouse Scenarios in SSIS. It’s an efficient pattern for performing inserts into large parent child dimensions that delivers its speed through only having to do 2 passes over the source data. It […] “Inserting into Large Parent Child Dimensions“ |
Month: January 2017
Inserting Facts with Late Arriving DimensionsIn John Welch’s SQLBits session on Handling Advanced Data Warehouse Scenarios in SSIS, he describes a pattern for handling late arriving dimension members for dimensional data warehouses. The pattern is oriented around high performance, and so avoids row-by-row SQL updates and non-cached […] “Inserting Facts with Late Arriving Dimensions” |
Deadlock Detection using Extended EventsIn this post I demonstrate deadlock detection for SQL Server using Extended Events, retrieving event data via both SSMS and T-SQL. Whilst Extended Events have been in the product since SQL Server 2008, the introduction of the SSMS-based GUI in SQL Server 2012 for managing and viewing […] “Deadlock Detection using Extended Events” |