Try to add

OPTION (RECOMPILE)

>For specific queries, when going parameterized, I have some major lack of performance. So, the following could be really long sometimes:
>
>

>DECLARE @Name varchar(20)
>DECLARE @Name2 varchar(20)
>DECLARE @ID integer
>set @Name = 'A301041%'
>set @Name2 = 'A301041%'
>set @ID = 1
>
>SELECT Client.Numero FROM Client WHERE (Client.Name LIKE @Name OR Client.Name2 LIKE @Name2) AND Client.ID=@ID
>

>
>This depends on the value entered. However, if I am not going parameterized, no matter the value, I will always get an optimized search result. But, for certain values, when going parameterized, it can take up to 8 to 50 seconds to find the same query.
>
>This has been discussed before. But, I really need to find what we need to adjust to avoid that.