Commercial database systems like SQL server have many recovery mechanisms to restore data hardware or software failure. Checkpoints are part of such recovery mechanism.SQL Server Database Engine is programmed...
2015-01-26
10 reads
As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in...
2015-01-20
1,947 reads
As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in physical memory, preventing the Windows operating system from paging...
2015-01-20
5 reads
As we know, when we create database on SQL Server instance, SQL Server engine sets the login that created the...
2014-12-28
1,870 reads
As we know, when we create database on SQL Server instance, SQL Server engine sets the login that created the database as the default database owner. This gives the...
2014-12-28
6 reads
Problem
I have a requirement to convert the binary data inside a table column or variable to a hexadecimal string. Is...
2014-09-11
4,423 reads
Problem I have a requirement to convert the binary data inside a table column or variable to a hexadecimal string. Is it possible to directly convert the binary data...
2014-09-11
14 reads
The following is the list of my articles published on SearchSQLServer.com from January 2014 to September 2014. To read these...
2014-09-09
900 reads
The following is the list of my articles published on SearchSQLServer.com from January 2014 to September 2014. To read these articles, you must be a member of SearchSQLServer.com. Learn...
2014-09-09
1 reads
The following is the list of my articles published on SSWUG.org from March 2014 to July 2014. To read these...
2014-08-08
863 reads
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...
Comments posted to this topic are about the item Doing Good at SQL Server...
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers