THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server Inte... » IsSorted » ssis   (RSS)
  • Merge Join component sorted outputs [SSIS]

    One question that I have been asked a few times of late in regard to performance tuning SSIS data flows is this: Why isn’t the Merge Join output sorted (i.e.IsSorted=True)? This is a fair question. After all both of the Merge Join inputs are sorted, hence why wouldn’t the output be sorted as well? Well here’s a little secret, the Merge Join ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 31, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement