put the SPID in the following code to see if it takes 100% of one of your cores, and please post your results

declare @Time datetime2(7)

declare @CPU66 bigint

declare @SPID int

set @SPID=

select...

Yes, every thing is the same, plans are the same.. Acctually i have a new lead, i found that for some reason the following query :

SELECT CASE ...