Prologika Forums

Making sense of data

Prologika (Teo Lachev's Weblog) » All Tags » Data Warehousing (RSS)

Browse by Tags

Blogs

Prologika (Teo Lachev's Weblog)

Home

Books

Learn PowerPivot and Analysis Services-Tabular at your own pace with our latest book Applied Microsoft SQL Server 2012 Analysis Services (Tabular Modeling). It is designed as an easy-to-follow guide for learning how to implement BI solutions spanning the entire personal-team-organizational BI spectrum.

Training

We offer onsite and online Business Intelligence classes! Contact us about in-person training for groups of five or more students.

For more information or to register click here!

Syndication

Reporting Services Links

Analysis Services Links

Blog Roll

Archives

Optimizing Massive SQL Joins

Scenario : Run ETL to perform a full data warehouse load. One of the steps requires joining four biggish tables in a stating database with 1:M logical relationships. The tables have the following counts: VOUCHER: 1,802,743 VOUCHER_LINE: 2,183,469 DISTRIB_LINE...

Published Sat, Mar 2 2013 8:12 PM by tlachev

Filed under: Data Warehousing
Gartner’s 2013 Data Warehouse Magic Quadrant

MVP fellow, Andrew Burst, discusses Gartner's newly released DW (not BI, mind you) magic quadrant. It looks like Gartner fell in love with Teradata but Microsoft is moving up as well thanks to the advances in its Parallel Data Warehouse (PDW) and...

Published Tue, Feb 5 2013 3:56 PM by tlachev

Filed under: Data Warehousing
Analysis Services Processing and CXPACKET Waits

Performance tuning – my favorite! This blog originated from a quest to reduce the processing time of an SSAS cube which loads some 2.5 billion rows and includes DISCINTCT COUNT measure groups. The initial time to fully process the cube was about 50 minutes...

Published Mon, May 14 2012 10:12 PM by tlachev

Filed under: Analysis Services, Data Warehousing
Columnstore Indexes To Speed ETL

SQL Server 2012 introduces columnstore indexes. Using the same in-memory VertiPaq engine that powers PowerPivot and Analysis Services Tabular, columnstore indexes can speed up dramatically SQL queries that aggregate large datasets. For a great introduction...

Published Wed, Dec 7 2011 7:48 PM by tlachev

Filed under: Integration Services, SQL Server 11, Data Warehousing
Disabling Foreign Key Constraints

Disabling check constraints, such as foreign key constraints, is often required when populating a data warehouse. For example, you might want to disable a check constraint to speed up loading of a fact table. How do we disable check constraints in SQL...

Published Wed, Oct 19 2011 1:33 PM by tlachev

Filed under: Data Warehousing

Powered by Community Server (Commercial Edition), by Telligent Systems

3DZL:andrewbelon.com

Browse by Tags

Blogs

Books

Training

Syndication

Recent Posts

Tags

Reporting Services Links

Analysis Services Links

Blog Roll

Archives

Optimizing Massive SQL Joins

Gartner’s 2013 Data Warehouse Magic Quadrant

Analysis Services Processing and CXPACKET Waits

Columnstore Indexes To Speed ETL

Disabling Foreign Key Constraints