Hi! I think I got to the bottom of this problem.

I've confirmed that deploying a trigger would recompile stored procedures that touch the underlying table. Thus it was a simple...

Thank you so much for the responses. Sounds like people who uses Database Mail have no complains. Plus it is good to know it uses an actual email server to...

The main search query is straight forward, here's the simplified version of it:

SELECT * FROM CONTAINSTABLE(dbo.SearchTable, (Col1, Col2), '(FORMSOF(THESAURUS,"keyword"))', 1000) AS FT

INNER JOIN dbo.IndexedViews IV (NOEXPAND) ON IV.ID = FT.[Key]

As...

Thanks for the reply. I usually noticed that the CPU spikes when Task Manager is started. So I am always a bit leery seeing 2 people running Task Manager on...