Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Performance Tuning, SQL Server 2008 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,227 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 | 3,844 reads
   Items 1 to 2 of 2   
 
Tags
data warehousing (1)    
sql server 2005 (1)    
star schemas (1)