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 >>