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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy