Search


	Podcast:		voiceofthedba's podcast
	Episode:		Killing FTS
	Category:		Technology
	Duration:		00:03:01
	Publish Date:		2019-06-23 19:00:00
	Description:		In almost every application that I've helped build, we had a need to perform textual searches of fields. Sometimes this was in short fields, like names, where we usually needed some sort of wildcard search to let users find information. When we got to larger volumes of text, such as note or description fields, it was essential that the application allow a way to find information that doesn't exactly match some term. SQL Server has had the Full-Text Search (FTS) subsystem for a long time. Built as an improvement over the LIKE keyword, FTS implements its own index system that better understands language and takes some burden off the developer when trying to find keywords and terms inside of a volume of text. However, this system hasn't advanced much since 2005, with limited improvements in each version, and more stable performance, but not substantially improved. New languages get added, but not development language improvement. Read the rest of Killing FTS
	Total Play:		0