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]
This post describes how to select the appropriate indexes, columns, and options when creating a full-text index over the documents and files stored in a FileTable in SQL Server 2012.
The FileTable feature in SQL Server 2012 makes it easier than ever to store documents and files in the database – you can simply drag them into the folder that represents the table in Windows Explorer, or you can save them directly from Windows applications like Microsoft Word or Excel. At the same time, SQL Server 2012 e...
[More]
This post describes the effects of stopwords when indexing and querying document properties in SQL Server 2012 Full-Text Search.
SQL Server 2012 Full-Text Search introduces the ability to search explicitly for document properties – such as Author, or even the Template that was used for a Microsoft Word document. For more information about property search, see the links later in this post.
How stopwords affect the indexing and querying of document properties
There's a very simple answer here – yo...
[More]
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]
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]
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]
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]