Size of the database is growing every day. Many organizations now a days have more than TB of the Data in their system. Performance is always part of the issue. Microsoft is really paying attention to the same and also focusing on improving performance for Data Warehousing. Microsoft has recently released whitepaper on the performance tuning subject of Data Warehousing.
Here is the abstract about the whitepaper from official site:
In this white paper we discuss two of the new features introduced in SQL Server 2008, Star Join and Few-Outer-Row optimizations. These two features are in SQL Server 2008 R2 as well. We test the performance of SQL Server 2008 on a set of complex data warehouse queries designed to highlight the effect of these two features and observed a significant performance gain over SQL Server 2005 (without these two features). The results observed also apply to SQL Server 2008 R2. On average, about 75 percent of the query execution time has been reduced, compared to SQL Server 2005. We also include data that shows a reduction in the number of rows processed and improved balance in parallel queries, both of which highlight the important role the Star Join and Few Outer-Row features played.
I encouraged all of those interested in Data Warehouse to read it and see if they can learn the tricks.
Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries
Reference: Pinal Dave (https://blog.sqlauthority.com)
Thanks for the article. The kind of architecture in place plays a great role in determining how efficient the data warehouse will behave. It is important to keep things like data volume and data growth in mind while planning out ETL/DW solutions.
Hi Pinal I liked ur site very much ,its very usefull.
I am fresher so pls can u send me materials related to sql.
I will be very Thankfull to you.