SQL Server Data Warehousing
Need help with using SQL Server for data warehousing, Change Data Capture, or decision support? Post your questions here.
Filtering and SortingUse these options to narrow down the question and discussion list.
- 8539

Star Schema modeling on Order Header/Details data
Garry168 Friday, April 19, 2013 6:58 PM - 2545

Pricing of PDW Appliance
JohnnyKahWang Tuesday, April 02, 2013 2:14 PM - 5748

T-SQL SCD2
ns100 Wednesday, March 27, 2013 4:01 PM - 2342

Forms templates for documenting DW analysis & design, + naming conventions
dexter-knudson Monday, April 15, 2013 11:24 PM - 4418

SQL
PetrovSerega Monday, April 15, 2013 1:36 PM - 1481

Design Pattern Question: Conformed dim used by facts sourced from different systems - inconsistent/reused dim reference keys
jakubk Thursday, March 28, 2013 3:01 AM - 2568

CDC function should generate an error, but doesn't
JasonChris Wednesday, April 03, 2013 9:22 PM - 6442

Dimensional Modelling.
VenSree Monday, March 25, 2013 11:37 PM - 1495

Hai
rajkat85 Saturday, March 23, 2013 2:59 AM - 2407

Combining Flags, Calculated Members and Overall Design
Julian1123 Friday, March 15, 2013 9:38 AM - 2493

when to create a new dimension?
ScottCabral Monday, March 11, 2013 9:03 PM - 2683

Dealing with somewhat related datasets: missing values, "top values"
Russ Loski Friday, March 08, 2013 12:38 PM - 78013

one size fits all architecture for star's etl
db042188 Monday, September 14, 2009 1:41 PM - 10886

Change Data Capture History
simonxy Monday, February 25, 2013 2:03 PM - 1803

What is stored in msdb.dbo.mdw_query_stats_staging?
Praveen Ganji Wednesday, February 27, 2013 12:12 PM - 6765

Dimension Attributes
ScottCabral Monday, February 25, 2013 2:26 PM - 1716

In Staging tables, is it a good practice to have primary/foreign keys and is it a good practice to set ALL table columns to Not Null?
hddeluxe09 Wednesday, February 27, 2013 3:57 PM - 2771

Dimensional Modeling: connecting SalesCube with Capacity(Cube)
J.Roca Friday, February 22, 2013 1:28 PM - 2667

Fact table data partitioning on SAN
SeverH Friday, February 22, 2013 3:39 PM - 28029

Odd characters added to exported csv file?
BJ Sanders Thursday, February 05, 2009 10:44 AM

