• Well worth a read when optimising for large datasets

    http://technet.microsoft.com/en-us/library/cc879317(v=sql.105).aspx