Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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,429 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,113 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,429 reads
   Items 1 to 20 of 34    Older >>
 
Tags
miscellaneous (24)    
maintenance and management (14)    
sqlinsider scripts (9)    
backup and 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)