March 28, 2025 at 12:00 am
Comments posted to this topic are about the item Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions
March 28, 2025 at 11:26 am
Thanks for mentioning the new interesting commands.
According to https://learn.microsoft.com/en-us/sql/t-sql/functions/jaro-winkler-distance-transact-sql?view=azuresqldb-current it's still in preview
March 28, 2025 at 11:14 pm
I wonder what the "compute cost" of these new functions is?
--Jeff Moden
Change is inevitable... Change for the better is not.
March 31, 2025 at 2:58 am
You are right. Its still in preview mode but you can try it on Azure SQL right now.
March 31, 2025 at 2:59 am
These functions cause index scan. I have not done deep analysis, but I am assuming it will similar to any scan operation.
April 3, 2025 at 6:23 am
I wonder what the "compute cost" of these new functions is?
I dont imagine this type of processing being done on a live OLTP system. More likely a read only DB or some type of warehouse.
A question I have: I wonder if column store indexes would help with the efficiency of this type of processing.
----------------------------------------------------
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply