Marios Philippopoulos (4/11/2011)
Craig Purnell (4/11/2011)
I think that's right.Thank you, we are developing some new FTS functionality and will test with the service down to see what happens.
The query below actually fails, when the filter daemon service is down; now I'm confused:
select col2 from tbl1
where freetext(col1, 'abcd')
Msg 30046, Level 16, State 1, Procedure sp_fulltext_service, Line 163
SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]