SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags T-SQL, SQL Server 2008, Performance Tuning Rss

   Items 1 to 2 of 2   

What's the best way to count?

By Dave 2010/10/19 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,302 reads

Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries

In this white paper we discuss two of the new features in SQL Server 2008, Star Join and Few-Outer-Row optimizations. 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).  Read more...
By Additional Articles 2009/09/10 | Source: Microsoft MSDN | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 4,655 reads
   Items 1 to 2 of 2   
data warehousing (1)    
sql server 2005 (1)    
star schemas (1)