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.