SQL Server 2012 Property Search Assistant published

This post describes a utility program that makes it easier to set up the Property Search feature in SQL Server 2012. I have just published the source code for the SQL Server 2012 Property Search Assistant on Codeplex. The SQL Server 2012 Property Search Assistant is a small utility program that helps you to configure the Property Search feature which is new in SQL Server 2012 Full-Text Search. The Property Search Assistant is written in C#. About Property Search in SQL Server 2012 Why do I need the Propert... [More]

Querying for registered search properties and lists in SQL Server 2012

This post discusses the new Property Search feature in SQL Server 2012 "Denali" Full-Text Search. In particular, it shows you how to get a list of the search properties that you've registered and the search property lists to which they belong by using a JOIN. SQL Server 2012 "Denali" now lets you search specifically for the values of built-in or custom document properties, such as the "Author" of a Microsoft Word document. However, before you can run queries, you have to register the properties that you wan... [More]

Get the Office 2010 Filter Pack for search in SQL Server 2012

SQL Server 2012 “Denali” installs the latest Microsoft word breakers and stemmers. However, it does not install the latest filters for Microsoft Office documents. If you want to use Full-Text Search or Semantic Search to index documents created by the most recent versions of Microsoft products, you have to download the latest filters. Get the latest filters To get the latest Microsoft filters: Download the appropriate version – 32-bit or 64-bit – from Microsoft Office 2010 Filter Pa... [More]

How near is NEAR in SQL Server 2012 Full-Text Search?

SQL Server 2012 “Denali” Full-Text Search introduces a new custom proximity operator, which we’ve been calling “customizable NEAR.” The new NEAR operator lets you query with 2 optional requirements that you could not previously specify: The maximum gap between the search terms. The order of the search terms. (For example, “John” must appear before “Smith.”) Here is a partial example of the new NEAR operator: CONTAINSTABLE (Documents, Content, 'NEAR((... [More]

More sample queries for Semantic Search in SQL Server 2012

Earlier today I published a blog post about Looping over document similarity details in Semantic Search on the MSDN blog of the SQL Server Full-Text Search team. That post introduces the 3 built-in rowset functions that are provided by Semantic Search in SQL Server 2012 “Denali.” It also describes how to do something for which we don’t provide a built-in set-based function – that is, iterate over the documents that are similar to a source document, and ask why each document is simila... [More]