What is new in SQL Server 2012 - Denali - SQL Server 2012 - Full Text Search Enhancements - Ability to search and filter within document properties

Getting Started with Adobe After Effects - Part 6: Motion Blur


	What is New

Upload Image

Close it

Select File

Find out the new features and enhancements added into SQL Server 2012, codenamed "Denali"

Moderators


	Like

Invite Friends

Top Categories · View All

TSQL Enhancements	28
Discontinued Features	16
SSIS Enhancements	10
SSMS Enhancements	10
Database Engine	10
Database Administration	8
Security	3
Full Text Search	2
DataTime	1
Breaking Changes	1

Browse by Tags · View All

Denali	82
SQL Server 2012	79
SSIS	9
SSMS Enhancements	9
Analytic Functions	8
Usability Enhancements	5
SQL11	4
TSQL	4
Security	3
Database Engine	3
Datetime	3
Query Hints	2
OVER Clause	2
DMV	2
Groups	2
Dynamic Management Functions	2
DMF	2
System stored procedures	2
DBA	2
FTS	2

Browse by Release · View All

All	58
RC0	20
SQL Server 2012 Denali	2
CTP3	2
SQL Server Denali	1

What is new in SQL Server 2012 - Denali

Features · Categories · Submit a feature · Most Liked · Most Discussed · Info · News · Fans (73) · Preferences

SQL Server 2012 - Full Text Search Enhancements - Ability to search and filter within document properties

Nov 29 2011 7:08AM by Jacob Sebastian

The following excerpt is taken from the FTS team blog which explains new Full Text Search enhancements added to SQL Server 2012 - Denali.

Besides performance and scale improvement, we also added support for property scoped searches over documents with file system properties stored with-in a fulltext enabled table. One can now issue a CONTAINS query looking for all documents containing a particular term and authored by a particular author without having to maintain a separate column for the Author name in the database.

Read More

Reference 1 [334 clicks]
Reference 2 [32134 clicks]
Reference 3 [32134 clicks]

Have you written a blog post or article related to this feature and want to get them added here? Read More...

Category :	Database Administration,Database Engine,Full Text Search
Release :	CTP3
Tags :	SQL Server 2012, Denali, Full Text Search, FTS

Jacob Sebastian

1 · 100% · 32002

3 Readers Liked this

	Jacob Sebastian Liked this on 12/24/2011 11:23:00 AM Profile · Blog · Facebook · Twitter
	Guru Samy Liked this on 3/30/2012 2:14:00 AM Profile · Blog
	Alpesh Patel Liked this on 7/4/2012 6:20:00 AM Profile

Liked


Post this to my facebook wall
Tweet this
Like This
I know a usecase where I can use this feature rightaway
I may use this sometime in the future
Interesting feature, but not my area of expertise
I dont think this feature adds any "real" value


	Submit

Your Comment

Sign Up or Login to post a comment.

"SQL Server 2012 - Full Text Search Enhancements - Ability to search and filter within document properties" rated 5 out of 5 by 3 readers +Jacob Sebastian

Moderators

What is new in SQL Server 2012 - Denali

SQL Server 2012 - Full Text Search Enhancements - Ability to search and filter within document properties

Your Comment