filmov
tv
Full Text Indexing Basics with Azure SQL | Data Exposed: MVP Edition
Показать описание
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:
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 credentials include undergraduate and graduate degrees in Computer Science from the University of Rhode Island. Also, he has earned certificates from Microsoft for Database Administration (MCDBA), System Administration (MCSA), Data Management & Analytics (MCSE) and Data
Science (MPP).
John has been recognized with the Microsoft MVP award six times for his outstanding contributions to the Data Platform community.
When he is not busy talking to local user groups or writing blog entries on new technology, he spends time with his wife and daughter enjoying outdoor activities. Some of John’s hobbies include wood working projects, crafting a good beer and playing a game of chess.
About MVPs:
📌 Let's connect:
🔔 Subscribe to our channels for even more SQL tips:
#MVPTuesday #AzureSQL #MVPBuzz #DataPlatformMVP
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:
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 credentials include undergraduate and graduate degrees in Computer Science from the University of Rhode Island. Also, he has earned certificates from Microsoft for Database Administration (MCDBA), System Administration (MCSA), Data Management & Analytics (MCSE) and Data
Science (MPP).
John has been recognized with the Microsoft MVP award six times for his outstanding contributions to the Data Platform community.
When he is not busy talking to local user groups or writing blog entries on new technology, he spends time with his wife and daughter enjoying outdoor activities. Some of John’s hobbies include wood working projects, crafting a good beer and playing a game of chess.
About MVPs:
📌 Let's connect:
🔔 Subscribe to our channels for even more SQL tips:
#MVPTuesday #AzureSQL #MVPBuzz #DataPlatformMVP
0:11:51
Full Text Indexing Basics with Azure SQL | Data Exposed: MVP Edition
0:09:28
Full-Text Search from FamilySearch | A Quick Tutorial
0:14:12
PostgreSQL Full Text Search Tutorial
0:10:04
SQLite for beginners: Full Text Search
0:02:17
SQL Server Tutorial - Enhancements to full text search
0:43:22
MongoDB - Back to Basics 4 - Advanced Indexing, Text and Geo-spatial Indexes
0:08:20
Text Indexing | MongoDB | Tutorial 9
0:24:51
MySQL Full Text Search Example - Tutorial
0:00:58
Simplify Your Writing with the FOG Index!
0:18:50
Using AWS Aurora For Full Text Search - Complete Tutorial
2:18:09
Complete Indexing Data Tutorial for Full Text Keyword in Azure AI Search using Azure Function in C#
0:10:40
SQLite Tutorial #30: Full Text Search in SQLite
0:31:50
Tutorial On Using Lucene With Text search
0:29:47
Oracle Optimization Tutorial, PL/SQL Course: Using Oracle Text for text Searches (Lesson 7)
0:09:53
What is Elasticsearch?
0:07:58
SQL Tutorial - How to search text in a Stored Procedure
0:10:24
Elastic Stack Tutorial ELK Stack 10 - Full text queries | Elasticsearch
0:18:06
MongoDB Tutorial 30 : Full text search in MongoDB
0:01:20
Full Text Tutorial
0:03:17
How to Search Text or Contents in Any Files - Windows 10 [Tutorial]
0:05:29
Natural Language Processing In 5 Minutes | What Is NLP And How Does It Work? | Simplilearn
0:05:12
Big Data In 5 Minutes | What Is Big Data?| Big Data Analytics | Big Data Tutorial | Simplilearn
0:00:56
Text Fire Effect Photoshop | Short Tutorial | Malayalam
0:00:57
Text to Speech mit JavaScript #tutorial #texttospeech #index
Комментарии