SQL Server Data Warehousing

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

• 4114
  

  how to fetch incremental data using SSIS

  
  KONDAPATURU Thursday, November 22, 2012 12:31 PM
  Last Reply Nishink 43 minutes ago
 
• 017
  

  MDX Query to calculate Average rather than Sum

  
  Mehawitchi 7 hours 22 minutes ago
 
• 2105
  

  Change Tracking

  
  ross135 Wednesday, November 21, 2012 11:55 AM
  Last Reply SQL Champ Friday, November 23, 2012 1:21 PM
 
• 5700
  

  Cube processing

  
  rkaura Tuesday, October 02, 2012 4:46 AM
  Last Reply Maciek Sowa Friday, November 23, 2012 12:09 PM
 
• 3173
  

  How to capture error messages for BCP when running through XP_CMDSHELL

  
  Naveen Raikwar Friday, November 16, 2012 1:18 PM
  Last Reply Eileen ZhaoMicrosoft Contingent StaffFriday, November 23, 2012 9:15 AM
 
• 7287
  

  Publish SQL Server data to clients from saas website with multi-tenant database?

  
  michael12345 Wednesday, November 14, 2012 10:56 PM
  Last Reply Piotr Palka Thursday, November 22, 2012 5:53 AM
 
• 1125
  

  SQL Stored Procedure Help

  
  Mira Pimbi Wednesday, November 21, 2012 2:26 AM
  Last Reply Thomas W Marshall Wednesday, November 21, 2012 10:20 PM
 
• 3367
  

  Data/Information LifeCycle Management -(DLM/ILM) - using SQL Server 2012

  
  veeraghav Friday, November 16, 2012 4:08 AM
  Last Reply ShriyaP Monday, November 19, 2012 5:25 PM
 
• 2220
  

  Peer to Peer Replication SQL Server 2008R2 Enterprise Edition

  
  dbSlave65 Thursday, November 15, 2012 6:30 PM
  Last Reply dbSlave65 Friday, November 16, 2012 8:05 PM
 
• 4437
  

  data warehouse

  
  sh-67 Thursday, November 08, 2012 8:59 AM
  Last Reply Piotr Palka Thursday, November 15, 2012 10:50 PM
 
• 8559
  

  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 Eileen ZhaoMicrosoft Contingent StaffTuesday, November 13, 2012 9:33 AM
 
• 2289
  

  SQL Server 2008 read-only performance improvement

  
  Asken12345 Tuesday, November 06, 2012 9:42 AM
  Last Reply Eileen ZhaoMicrosoft Contingent StaffTuesday, November 13, 2012 3:12 AM
 
• 3247
  

  Changing Dimension Attribute Names in a Cube

  
  Mira Pimbi Monday, November 12, 2012 4:28 AM
  Last Reply Nishink Monday, November 12, 2012 2:02 PM
 
• 4304
  

  Data update in Datawarehouse

  
  RR Netha Wednesday, November 07, 2012 7:28 AM
  Last Reply ssisrocks Monday, November 12, 2012 12:22 PM
 
• 41128
  

  Exam 70-463

  
  Hany.Helmy Monday, September 17, 2012 7:58 AM
  Last Reply Hany.Helmy Sunday, November 11, 2012 7:24 PM
 
• 4396
  

  Guids in Data Warehouse

  
  BI_Baracus Friday, November 09, 2012 3:05 PM
  Last Reply BI_Baracus Sunday, November 11, 2012 12:48 PM
 
• 12390
  

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

  
  Mehawitchi Saturday, November 03, 2012 8:14 PM
  Last Reply Mehawitchi Friday, November 09, 2012 6:53 PM
 
• 2277
  

  Fact Data Table & References data in DataWarehouse

  
  rookie_ssis Wednesday, November 07, 2012 1:30 PM
  Last Reply rookie_ssis Thursday, November 08, 2012 8:47 AM
 
• 1308
  

  Calculating database and server growth over five year period

  
  reporter-reporter Wednesday, November 07, 2012 5:42 PM
  Last Reply Rama UdayaMicrosoft Community ContributorThursday, November 08, 2012 3:54 AM
 
• 2376
  

  Use of Change tracking

  
  Sankaran K S Wednesday, October 31, 2012 4:41 AM
  Last Reply Varsha Mishra Tuesday, November 06, 2012 5:06 PM