Improve SqlServer Support: Add Full Text Search When Available #3
Description
Feature Request
Enhance the SqlServer support to utilize full text search features when available. The implementation should:
- Detect if full text search is enabled and supported in the target SqlServer instance.
- Only use full text search if the database feature is available and configured.
- Fallback to default search behavior if full text search is not available.
Motivation:
This would provide more efficient and powerful search capabilities for projects using SqlServer with full text search, while maintaining compatibility for instances where the feature is not enabled.
Acceptance Criteria:
- Add logic to detect presence and configuration of full text search in SqlServer.
- Implement full text search integration where possible.
- Ensure robust fallback if feature is not present or enabled.
- Add documentation and usage examples for projects with and without full text search.
** To Decide **
Which columns should be indexed? As a starting point, I would suggest a search on enterprise denominations.