Look this points.

1. Change Database Tempdb to recovery model Simple. (Default). The others recovery model is not necesary because you don´t recover the tempdb database never and the performance is...

Hello,

SQL server use serveral methods to optimize. I observed than the optimizer change when the table is large >1.000.000 records. SQL decide use the force (parallel scan)

If you want same...