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.
- 1541
SSIS Auditing Mechanism?
Mira Pimbi Thursday, April 18, 2013 1:09 AM - 1527
How would my fact and dim tables look like in this example?
vmhatup Wednesday, April 17, 2013 5:16 PM - 5856
T-SQL SCD2
ns100 Wednesday, March 27, 2013 4:01 PM - 2403
Forms templates for documenting DW analysis & design, + naming conventions
dexter-knudson Monday, April 15, 2013 11:24 PM - 4899
Where to find best practices for tuning data warehouse ETL queries?
SQL Server dude Wednesday, April 03, 2013 9:01 PM - 4490
SQL
PetrovSerega Monday, April 15, 2013 1:36 PM - 1543
SQL Server Inserting Dummy Rows to Fact Table for each id's for a month if the id is missing for the Month
anoopcse Thursday, April 11, 2013 2:43 AM - 1548
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 - 32218
Need some clarifications on Sql Server 2012 QA & Prod environment setup
sujitj Thursday, December 20, 2012 7:57 AM - 2633
CDC function should generate an error, but doesn't
JasonChris Wednesday, April 03, 2013 9:22 PM - 2562
Replace function ineffective with the string more than 90 chars
Devanathan thiru Tuesday, April 02, 2013 7:04 PM - 3538
Data replicated from a Table to a Table across database
badri prasad Tuesday, April 02, 2013 10:45 AM - 1416
A Problem in time
BI_Baracus Tuesday, April 02, 2013 12:33 PM - 2565
need example about Measure types in fact
surendiran Wednesday, March 27, 2013 9:24 AM - 2478
Building a data warehouse from scratch - Best book
Sirow08 Wednesday, March 20, 2013 12:32 PM - 1364
Converting Rows to columns
Lbrec Monday, March 25, 2013 2:16 AM - 2490
Chnage in Recovery mode
anupamk Tuesday, March 26, 2013 7:15 AM - 3641
Conceptually, what would this data warehouse look like?
vmhatup Thursday, March 21, 2013 8:33 PM - 1426
PDW columnstore indexes
SQLpro26 Monday, March 25, 2013 4:17 PM - 6497
Dimensional Modelling.
VenSree Monday, March 25, 2013 11:37 PM