>My execution plan displays a parallelism syntax when I use the LIKE clause. If I do not, this does not apply. Is there a way to avoid the parallelism when using the LIKE clause or this is just normal as is?
Set MAXDOP=1 option for the query in question
--sb--