Full Text Indexing Basics with Azure SQL | Data Exposed: MVP Edition

From the creator

Today’s large data fields (LDF) are full of unstructured information stored in varchar, text, varbinary or xml data types. How do you write an application to search the column for patterns? Traditional SQL techniques using a column INDEX and LIKE operator result in a query plan that contains a full table scan. This will result in poor query performance for large tables. During this episode of Data Exposed: MVP Edition with Anna Hoffman and John Miner, they'll introduce the brothers Grimm database that has the full text of each fairy tale. They will create a full-text catalog/index, select a change tracking strategy, define an optional stop list/thesaurus file, and then populate the index. And they will use CONTAINS and FREETEXT operators in SELECT queries to leverage the newly created FTI. The resulting query plan uses an index seek with better query performance. 0:00 Introduction 01:28 Modern Data Types 02:10 Fairy Tales 02:40 Searching for Patterns 03:22 Demo 09:26 Best Practices ✔️ Resources: Github: https://github.com/JohnMiner3/community-work/tree/master/full-text-indexing About John Miner: John Miner is a Senior Data Architect at Insight Digital Innovation helping corporations solve their business needs with various data platform solutions. He has over thirty years of data processing experience, and his architecture expertise encompasses all phases of the software project life cycle, including design, development, implementation, and maintenance of systems. His cre

Published 2022-09-27 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.