• But if you are asking about a SQL Server 2016 instance in the 2008 forum, if people here are not running 2016, as many are not, you're not going to get good 2016 answers. The languages and options and capabilities have changed quite a bit from 2008.

    Here is the other thread.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning