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

Content with tags Data Warehousing, Performance Tuning Rss

   Items 1 to 2 of 2   

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,719 reads

Importing And Analyzing Event Logs

Another new author! Gheorge shares some ideas about importing event logs and using OLAP to analyze the results. Not a bad idea at all. How many of use OLAP as often as we should? Read the article, see if it's something you want to try - and let Gheorge know what you think!   Read more...
By Gheorghe Ciubuc 2003/05/28 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,806 reads
   Items 1 to 2 of 2   
administration (1)    
analysis services (ssas) (1)    
miscellaneous (1)    
olap server (1)    
programming (1)    
sql server 2008 (1)    
sql server 7 (1)    
star schemas (1)    
t-sql (1)