Handle a late-arriving dimension with inferred members, preserve fact keys, fill attributes later, and report unresolved placeholders.
SQLAuthority News – Fast Track Data Warehouse 3.0 Reference Guide
The Fast Track Data Warehouse 3.0 reference guide is out. It gives a method and real examples for balancing hardware and database setup for data warehouse loads.
Slowly Changing Dimensions in Plain T-SQL
Slowly changing dimensions need explicit Type 1 and Type 2 rules; use T-SQL updates and inserts with tests for history and overlap.
Loading a Fact Table Without Blocking Reports
Loading a fact table without blocking reports calls for isolated staging, aligned partition switching, short locks, and a tested reader path.
Star Schema Queries and How SQL Server Runs Them
Star schema queries join a large fact table to focused dimensions; learn bitmap filters, columnstore, and indexes that support the real workload.
Partitioning a Large Fact Table
Partitioning a large fact table can simplify loading and retention when boundaries, aligned indexes, and switch rules are designed together.
Finding the One Row That Broke Your Data Load
Trace a data load error to its source row with raw staging, TRY_CONVERT, stable row identifiers, and a rejection report that supports a safe retry.