Bad performance when using parameterized query with like in where clause.

• sqlTobi

  Right there with Babe

  Points: 739

  More actions

  February 13, 2014 at 12:40 pm

  #1688902

  In the plan xml there are only the first ~6000 characters of the statement.

  The Navision querries can be very long. So the interresting parts are missing (same in deadlock graphs etc.).

  Any chance to link from plan to sys.dm_exec_sql_text()?

  select * from sys.dm_exec_sql_text(convert(varbinary(64),'0x7739E88A9758BB5D', 1));

  doesn't work. The handle is invalid. I've taken the QueryHash from the plan xml as the sql_handle.

  best

  Tobias