SQL Server Data Warehousing

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

• 2390
  

  SQL Server 2008 and DATAllegro

  
  Toby.NY Friday, October 12, 2012 12:40 AM
  Last Reply Toby.NY 6 hours 52 minutes ago
 
• 295
  

  How to Join a Fact Table to an Unrelated Dimension Table?

  
  Mehawitchi Saturday, November 03, 2012 8:14 PM
  Last Reply Mehawitchi 12 hours 8 minutes ago
 
• 3105
  

  how to pass parameter in ado.net source

  
  Shailendra17 Sunday, November 04, 2012 5:33 AM
  Last Reply dheNewBee 17 hours 31 minutes ago
 
• 4230
  

  Issue inserting records into a dimension when source has multiple records with the same business key

  
  John Edwards NZ Thursday, November 01, 2012 1:35 AM
  Last Reply John Edwards NZ Sunday, November 04, 2012 8:19 PM
 
• 6209
  

  Incremental Loading of Staging Table - Re-running Import for Same Window

  
  Ian Saunder Wednesday, October 31, 2012 11:26 AM
  Last Reply Ian Saunder Friday, November 02, 2012 6:00 AM
 
• 1115
  

  Dimenssion design question

  
  Furious Fox2 Thursday, November 01, 2012 9:31 AM
  Last Reply BillAnton Thursday, November 01, 2012 9:48 AM
 
• 1145
  

  Use of Change tracking

  
  Sankaran K S Wednesday, October 31, 2012 4:41 AM
  Last Reply irusul Wednesday, October 31, 2012 4:10 PM
 
• 4187
  

  Suggestions needed: Warehousing

  
  Markus Pöhler Tuesday, October 30, 2012 5:08 PM
  Last Reply Reza RaadMVPWednesday, October 31, 2012 12:10 PM
 
• 3180
  

  SQL installation

  
  satyadev.srm Monday, October 29, 2012 11:52 AM
  Last Reply Steve Hughes - Magenic Tuesday, October 30, 2012 6:19 PM
 
• 1158
  

  Please provide websites and ebooks for SQL SERVER DBA(beginner)

  
  samba cheedella Tuesday, October 30, 2012 9:36 AM
  Last Reply Manish_BI Tuesday, October 30, 2012 9:56 AM
 
• 3602
  

  SSIS task used for SSAS cube processing

  
  rkaura Thursday, October 04, 2012 12:20 AM
  Last Reply Anand BI Tuesday, October 30, 2012 5:33 AM
 
• 1456
  

  Dimensional Model for Pathing Analysis

  
  Tinto James Thursday, October 18, 2012 12:17 PM
  Last Reply Eileen ZhaoMicrosoft Contingent StaffThursday, October 25, 2012 7:17 AM
 
• 1263
  

  CDC capture instance

  
  AndyMN Wednesday, October 24, 2012 6:09 PM
  Last Reply Eileen ZhaoMicrosoft Contingent StaffThursday, October 25, 2012 6:55 AM
 
• 2283
  

  hi i need help regarding dummy row insertion into datawarehouse table

  
  Shailendra17 Tuesday, October 23, 2012 7:37 AM
  Last Reply Shailendra17 Tuesday, October 23, 2012 7:53 AM
 
• 71632
  

  DBCC Shrinkfile cannot identify log from stored logical name post SP3 update

  
  idcowden Friday, August 10, 2012 12:41 PM
  Last Reply idcowden Monday, October 22, 2012 9:06 AM
 
• 2310
  

  CDC

  
  AndyMN Friday, October 19, 2012 9:05 PM
  Last Reply Boris Frolov Sunday, October 21, 2012 2:46 PM
 
• 2337
  

  UNIQUE NONCLUSTERED INDEX or COMPOSITE PRIMARY KEY

  
  PadmaSatya Saturday, October 20, 2012 9:14 AM
  Last Reply Boris Frolov Saturday, October 20, 2012 5:12 PM
 
• 1318
  

  Merge statment accross servers

  
  Sarah2005 Wednesday, October 17, 2012 6:48 PM
  Last Reply Yogish Bhat Thursday, October 18, 2012 4:52 AM
 
• 4567
  

  Streaming high volume real time data into SQL Server PDW

  
  virtusit Thursday, October 11, 2012 10:18 AM
  Last Reply Reza RaadMVPMonday, October 15, 2012 8:03 PM
 
• 2414
  

  replication

  
  monirkitl Friday, October 12, 2012 8:43 AM
  Last Reply monirkitl Saturday, October 13, 2012 6:21 AM