SQL Server Data Warehousing

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

• 07
  

  Data warehouse builder

  
  farhad koohbor 1 hour 23 minutes ago
 
• 07
  

  CDC other relational database

  
  HenriqueLimaINTERA 2 hours 7 minutes ago
 
• 029
  

  EMC SAN horrible performance for a 1TB DW

  
  Willgart1 13 hours 25 minutes ago
 
• 2167
  

  sp_updatestats or UPDATE STATISTICS <statistics name> vs alter index all table rebuild fillfactor(90)

  
  rajemessage Friday, May 18, 2012 12:33 PM
  Last Reply Alex Volok Tuesday, May 22, 2012 8:41 AM
 
• 2139
  

  Data removed automatically from Change Data Capture configured table.. How??

  
  Vidhyut Kediya Monday, May 21, 2012 6:01 AM
  Last Reply Alex Volok Tuesday, May 22, 2012 8:25 AM
 
• 1214
  

  Updation Querey

  
  Asrar Nazir Friday, May 18, 2012 7:15 AM
  Last Reply Rusul Ibrahimi Saturday, May 19, 2012 9:39 PM
 
• 1141
  

  Loading a dimension table from a NDS

  
  MrFlinstone Friday, May 18, 2012 3:27 PM
  Last Reply Rusul Ibrahimi Saturday, May 19, 2012 9:19 PM
 
• 47067
  

  Connect to Access 2010 database - how?

  
  Ihor Bobak Thursday, November 25, 2010 2:54 PM
  Last Reply S Kumar Dubey Saturday, May 19, 2012 9:01 AM
 
• 1113
  

  Newbie (Install Developer edition 2012)

  
  KIWI DAVE Saturday, May 19, 2012 6:08 AM
  Last Reply Olaf HelperMicrosoft Community ContributorSaturday, May 19, 2012 6:18 AM
 
• 4710
  

  What is the recommended way to backup a datawarehouse database?

  
  Suresh Channamraju Thursday, May 03, 2012 4:03 PM
  Last Reply Alex Volok Friday, May 18, 2012 12:41 PM
 
• 2266
  

  BI Architect or BI Data Modeller

  
  Ismailc Wednesday, May 16, 2012 11:04 AM
  Last Reply Ismailc Friday, May 18, 2012 12:30 PM
 
• 2283
  

  Is using indexed views to create aggregate tables a good idea?

  
  MariusBIDW Wednesday, May 16, 2012 6:25 AM
  Last Reply Alex Volok Thursday, May 17, 2012 12:18 PM
 
• 3346
  

  What is the quickest way to move data between SQL Server 2008 R2 and SQL Server 2012

  
  MariusBIDW Wednesday, May 16, 2012 6:06 AM
  Last Reply Zaim Raza Thursday, May 17, 2012 12:46 AM
 
• 23318
  

  balance fact table and view

  
  Pan Dabrowski Wednesday, October 12, 2011 1:32 PM
  Last Reply Mehdi1364 Wednesday, May 16, 2012 11:14 AM
 
• 6734
  

  can't get AdventureWorks2008R2 multidimensional model installed

  
  Axel96 Tuesday, May 08, 2012 7:21 AM
  Last Reply Zaim Raza Wednesday, May 16, 2012 2:21 AM
 
• 2674
  

  Updation of Huge data Issue During Denormalization

  
  Mubin4all Wednesday, May 02, 2012 5:33 PM
  Last Reply Meer Al - MSFT Tuesday, May 15, 2012 2:32 PM
 
• 45976
  

  Low Memory Usage of sqlservr.exe - Performance Problems

  
  happy-5 Thursday, March 10, 2011 7:57 AM
  Last Reply Leonardo Martínez P Tuesday, May 15, 2012 1:27 PM
 
• 3467
  

  MDX for current user

  
  DeanB61 Friday, May 11, 2012 10:28 AM
  Last Reply RaunakJhawar Monday, May 14, 2012 12:15 PM
 
• 1393
  

  CDC on Column

  
  Navind Friday, May 11, 2012 3:36 AM
  Last Reply Shehap Friday, May 11, 2012 7:57 AM
 
• 4810
  

  What is a Data Mart ?

  
  nadirsql Monday, April 30, 2012 1:40 AM
  Last Reply Leonardo Martínez P Thursday, May 10, 2012 8:18 PM