• Ulysses_Infinity (1/13/2012)


    This is a fairly poor Featured Script. Isn't the point to shed some light on the methodology rather than simply posting script and result. And where's the DDL code?

    Try these articles by Jeff Moden which talk about the same technique in much more detail -> Part 1[/url] and Part 2[/url]


    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/