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

Content with tags Data Warehousing, T-SQL Rss

   Items 1 to 20 of 34    Older >>
 

SQL 2008 MERGE using Dynamic SQL over a Linked Server

Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.   Read more...
By Tommy Bollhofer 2010/05/31 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,336 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,807 reads

SQL 2008 MERGE using Dynamic SQL over a Linked Server

Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.   Read more...
By Tommy Bollhofer 2010/05/31 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,336 reads
   Items 1 to 20 of 34    Older >>
 
Tags
miscellaneous (24)    
maintenance and management (14)    
sqlinsider scripts (9)    
backup / restore (2)    
replication (2)    
sql server 2008 (2)    
advanced querying (1)    
analysis services (ssas) (1)    
indexing (1)    
mail (1)    
merge (1)    
performance tuning (1)    
programming (1)    
star schemas (1)