Jose Manuel Jurado Diaz digs into a customer problem:
Today, we got a new service request where our customer asks about the time spent populating the full-text. Following, I would like to share with you some lessons learned during this process, specifically working with Azure SQL Database.
For this example, we are going to use a General Purpose database with 8 vCores. Let’s get started with the creation of the table and fulltext.
Read on for a walkthrough of setting up full-text indexing and figuring out what the indexing engine is doing at any point in time.