Jun
11
2012

Store and index your documents in less than 5 minutes

This blog post describes an article that I recently published on the Microsoft TechNet Wiki titled, "Store and Index Documents in SQL Server 2012 - An End-to-End Walkthrough." I recently published an article on the TechNet Wiki that highlights two new features in SQL Server 2012 that make it both easier and more valuable to store your documents and files in the database: FileTables, and Semantic Search. The wiki article captures a timed walkthrough of the steps required to configure a SQL Server 2012 docume... [More]
May
1
2012

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]
Apr
12
2012

Creating a Full-Text Index on a FileTable in SQL Server 2012

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]
Mar
5
2012

How stopwords affect Property Search in SQL Server 2012 Full-Text Search

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]
Feb
22
2012

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]
Nov
17
2011

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]
Nov
2
2011

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]