Great!

This is the reason. I tried to execute the same query in ssms setting arithabort of and i've had the same execution plan as the profiler.

Do you know how can...

Hi

When u create a cluster index, the table data are in the index (THE CLUSTER INDEX IS THE TABLE). So if u create cluster index on indexDrive , table data...

Thanks for your reply.

Now it seems the problem is 'fixed'.... i don't know why but i supposed it was a caused by query optimizer....

I have a view that join 6...

Indeed i don't need to encrypt sensitive... But my job has multiple steps, every step call a dtsx (saved on filesystem) with the same protection level (EncryptSensitiveWithUserKey), but i...