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
