FIX: Poor performance when you use table variables in SQL Server 2012 or SQL Server 2014 :: KB2952444

The performance issue with Table variables with many rows and then join it with other tables has ben fixed by as explained in KB2952444. Before the fix which applied to SQL Server 2012 SP2 and later, the query optimizer may choose an inefficient query plan, which may lead to slow query performance.

https://support.microsoft.com/en-us/kb/2952444

FIX: Poor performance when you use table variables in SQL Server 2012 or SQL Server 2014 :: KB2952444