SELECT query slow even with nonclustered Index and a full-text index
Each of the elements in the where clause are using functions. When functions are used sql cannot determine what index to use. It cannot determine what fields are in the where clause causing a table scan. 


Converge the date between to date => and date =&lt;
Is the database really case sensitive? Can you get rid of the lower()
Can you turn the contains into a patindex