A SQL Server data warehouse has its own characteristics and behavioral properties which makes a data warehouse unique. In this sense, a data warehouse infrastructure needs to be planned differently to that of a standard SQL Server OLTP database system. In this tip we look at some things you should think about when planning for a data warehouse.
Read more at https://www.mssqltips.com/sqlservertip/5872/infrastructure-planning-for-a-sql-server-data-warehouse/
