SQL Server Data Warehousing

Need help with using SQL Server for data warehousing, Change Data Capture, or decision support? Post your questions here. 

• 2212
  

  Currency Exchange rates in SQL

  
  Swetha Monpara Tuesday, April 30, 2013 6:51 PM
  Last Reply Swetha Monpara Thursday, May 02, 2013 10:11 PM
 
• 2266
  

  Data warehouse

  
  Asavari.m Tuesday, April 30, 2013 6:19 AM
  Last Reply Marko Frntic Thursday, May 02, 2013 5:50 AM
 
• 1243
  

  Workload Management for PDW V2

  
  SQLpro26 Tuesday, April 30, 2013 7:01 PM
  Last Reply Serena Williams Thursday, May 02, 2013 2:36 AM
 
• 1255
  

  Table Partitioning in warehouse database.

  
  SQListic Tuesday, April 30, 2013 7:07 PM
  Last Reply davidbaxterbrowneMicrosoft EmployeeTuesday, April 30, 2013 7:17 PM
 
• 1329
  

  Datawarehouse 33503 SQL-Server-Error

  
  L.Florian Friday, April 26, 2013 8:41 AM
  Last Reply TheSmilingDBA Monday, April 29, 2013 1:47 PM
 
• 6499
  

  Recovery model for DWH databases

  
  sqluser786 Wednesday, April 17, 2013 7:24 AM
  Last Reply sqluser786 Monday, April 29, 2013 1:38 PM
 
• 4399
  

  Can page breaks be programmatically controlled by code or expressions?

  
  SACSgtMike Thursday, April 25, 2013 1:19 PM
  Last Reply SACSgtMike Sunday, April 28, 2013 12:10 PM
 
• 8556
  

  Star Schema modeling on Order Header/Details data

  
  Garry168 Friday, April 19, 2013 6:58 PM
  Last Reply Mike Lewis (mzz3lh) Tuesday, April 23, 2013 8:12 AM
 
• 2555
  

  Pricing of PDW Appliance

  
  JohnnyKahWang Tuesday, April 02, 2013 2:14 PM
  Last Reply JohnnyKahWang Monday, April 22, 2013 2:07 PM
 
• 1456
  

  Optimum DR strategy for datawarehouse DBs

  
  sqluser786 Friday, April 19, 2013 2:10 AM
  Last Reply V. Keerthi Deep Friday, April 19, 2013 9:41 AM
 
• 1487
  

  SSIS Auditing Mechanism?‏

  
  Mira Pimbi Thursday, April 18, 2013 1:09 AM
  Last Reply Bendare2 Thursday, April 18, 2013 2:12 AM
 
• 1472
  

  How would my fact and dim tables look like in this example?

  
  vmhatup Wednesday, April 17, 2013 5:16 PM
  Last Reply Bendare2 Wednesday, April 17, 2013 6:58 PM
 
• 5771
  

  T-SQL SCD2

  
  ns100 Wednesday, March 27, 2013 4:01 PM
  Last Reply Bendare2 Wednesday, April 17, 2013 1:28 PM
 
• 2362
  

  Forms templates for documenting DW analysis & design, + naming conventions

  
  dexter-knudson Monday, April 15, 2013 11:24 PM
  Last Reply dexter-knudson Wednesday, April 17, 2013 5:43 AM
 
• 4801
  

  Where to find best practices for tuning data warehouse ETL queries?

  
  SQL Server dude Wednesday, April 03, 2013 9:01 PM
  Last Reply SQL Server dude Tuesday, April 16, 2013 9:18 PM
 
• 4441
  

  SQL

  
  PetrovSerega Monday, April 15, 2013 1:36 PM
  Last Reply PetrovSerega Tuesday, April 16, 2013 6:32 PM
 
• 1472
  

  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
  Last Reply Reza RaadMVPTuesday, April 16, 2013 3:14 AM
 
• 1495
  

  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
  Last Reply TheSmilingDBA Wednesday, April 10, 2013 3:06 PM
 
• 32115
  

  Need some clarifications on Sql Server 2012 QA & Prod environment setup

  
  sujitj Thursday, December 20, 2012 7:57 AM
  Last Reply Souvik4MSBI Wednesday, April 10, 2013 12:22 PM
 
• 2583
  

  CDC function should generate an error, but doesn't

  
  JasonChris Wednesday, April 03, 2013 9:22 PM
  Last Reply JasonChris Monday, April 08, 2013 11:25 AM