I have sql server table Bookchapter with about ~ 140.000 rows, FullContent field is nvarchar (max) with long content inside.
SELECT COUNT(Id) AS Expr1
FROM dbo.BookChapter
WHERE (FullContent LIKE '%xxx%')
without Where clause, it runs fine but with Where Clause involved with Fullcontent, sql server always cause timeout expired
I have no idea how to get it to work.