單筆更新避免Lock

UPDATE dbo.tbTable1 WITH (ROWLOCK)
SET Column1=1
WHERE PKey=1
OPTION (MAXDOP 1);

CHARINDEX v.s LIKE 效能

經實測,
CHARINDEX('KeyWord') 效能
不如 LIKE '%KeyWord%' 語法,
請善用 LIKE 語法.