InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 12:15:31 GMT20http://www.sqlservercentral.com/Forums/Topic1412112-147-1.aspxYour question isn't entirely clear for me.How many servers do you have?What is the "BI server"?Mon, 28 Jan 2013 05:52:23 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1412112-147-1.aspxI’m starting to build the DM design for BI data warehouse; I have two SQL server 2008 databases that will create the ETL to read from them what is the best physical structure I should consider? Should I create the new database warehouse on the same source database server? or should I install new SQL server instance for the warehouse database ? Or should I install MS SQL Server 2008 on the same server where my BI server is and create the database there? Which choice will be better for ETL best performance?Sun, 27 Jan 2013 03:07:07 GMTaman_work