SQL Server 2012 FTS是否支持点击突出显示？ [英] Will SQL Server 2012 FTS have native support for hit highlighting?
问题描述
有谁知道SQL Server 2012 FTS是否会支持点击高亮？
自从第一次测试以来，我一直在玩SQL Server 2012，这不是我听说过的全文增强功能（并且我在我的演示中讨论了其他几个人的新功能在各种事件中，包括对邻近和语义搜索的改变）。
编辑
<看起来像点击高亮是2007年的一个重要功能，根据连接项目＃295100：全文搜索摘要（点击高亮）。但尽管微软发表评论称这是一项重要功能，并且他们在2008年没有添加它，只是因为它们耗尽了时间，但我们仍然没有在2008 R2或2012年看到它，并且此项目已经没有任何进一步的解释，关闭为无法修复。我会尽力争取更多的信息（我在雷德蒙德有几个插件），但我不能答应任何事情。在此期间另一个已打开： Connect Item＃722324：如果SQL全文搜索提供了片段/突出显示支持，那会很好。这个可能会被作为上述项目的副本关闭，或者简单地关闭为无法修复。除非有令人信服的信息让他们做其他事情。你可能想要为这两个项目投票（即使是关闭的项目），并添加一条解释你的用例的注释。虽然选票可以算作某种东西，但您可能会认为这些建议正在被刷除，因为选票数量并不高，这绝对不是唯一的因素。为了证明对新功能的投资，他们需要有充分的证据证明添加该功能可以节省商业资金，提高效率，增加盈利或销售更多许可证。所以不要只说我想要它 - 解释原因。我在去年九月的博客文章中详细了解了有关定性错误评论的一些细节，标题为希望你的bug修复？提交一个好的bug！不要介意标题，还有关于建议的信息，而不仅仅是bug。
2ND编辑
我接触过一个名为ThinkHighlight提供此功能。我没有机会彻底地测试它或提供一个体面的评论，但我可以告诉你它确实如你所期望的那样：提供跨语言的灵活突出显示。
http://www.interactivethoughts.com/products/thinkhighlight/
Sql Server 2008 does not natively support hit highlighting in its FTS functionality, and currently you must implement yourself using a variety of techniques. Microsoft has made some vague noises about including it in future SQL Server releases.
Does anyone know if SQL Server 2012 FTS will have native support for hit-highlighting?
I've been playing with SQL Server 2012 since the very first beta and this is not a full-text enhancement that I have heard of (and I have been talking about several others in my presentations on new features at various events, including the change to proximity and semantic search).
EDIT
Seems like hit-highlighting was an "important feature" back in 2007, according to Connect Item #295100 : Full-text search summaries (hit-highlighting). But in spite of that comment from Microsoft that it is an important feature and they didn't add it in 2008 only because they ran out of time, we still don't see it in 2008 R2 or 2012, and the item has since been closed as "Won't Fix" without any further explanation. I will try to prod for more information (I have a few ins over in Redmond) but I can't promise anything. Another one has been opened in the meantime: Connect Item #722324 : Would be nice if SQL Full Text Search provided snippet / highlighting support. This one will probably be closed either as a duplicate of the above item, or simply closed as "Won't Fix." Unless there is compelling information for them to do otherwise. Which is where you come in!
You may want to vote for these two items (even the one that's closed) and add a comment explaining your use case. While votes do count for something, and you might think these suggestions are being brushed off because the vote counts aren't high, that's definitely not the only factor involved. In order to justify investment in new features they need to have substantial evidence that adding the feature will save a business money, make them more productive, make them more profitable, or sell more licenses. So don't just say "well I want it" - explain why. I get into some details about qualitative bug comments in my blog post from last September, entitled, "Want your bug fixed? File a good bug!" Never mind the title, there is information about suggestions too, not just bugs.
2ND EDIT
I've had some exposure to a new plugin called ThinkHighlight that provides this functionality. I haven't had the opportunity to thoroughly test it or provide a decent review, but I can tell you that it does exactly what you would expect: provide flexible hit highlighting across languages.
http://www.interactivethoughts.com/products/thinkhighlight/
这篇关于SQL Server 2012 FTS是否支持点击突出显示？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
