SQL Server 2014: Partition Improvements
SQL Server 2014 has enhancements to two common database maintenance operations:Partition Switching and Online Index Rebuild. This will greatly increase...
2013-09-26
1,222 reads
SQL Server 2014 has enhancements to two common database maintenance operations:Partition Switching and Online Index Rebuild. This will greatly increase...
2013-09-26
1,222 reads
Sometimes I see confusion on the difference between a data warehouse (DW) and master data management (MDM). Below is a...
2013-09-24
1,445 reads
I first blogged about Power BI for Office 365 two months ago (see Power BI for Office 365) when it was...
2013-09-19
1,079 reads
SQL Server Data Tools (SSDT) has a new update:
VS 2010: August 2013 version: 10.3.30822.0, June 2013 version: 10.3.30618.1, December 2012 version: 10.3.21208.0,...
2013-09-17
1,241 reads
The Certified Master and Architect community was collectively notified Friday, August 30, at 10PM PST that the Certified Master (MCM/MCSM)...
2013-09-12
1,494 reads
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the Houston Area SQL Server User Group Monthly Meeting....
2013-09-11
952 reads
All the videos for this popular conference are online (69 of them). Take a look at the recorded sessions at http://sqlbits.com/content/Event11. ...
2013-09-10
1,005 reads
A vendor management system (VMS) is a web-based application that acts as a mechanism for businesses to manage and procure...
2013-09-05
1,471 reads
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for the PASS DBA Fundamentals Virtual Chapter. The abstract is...
2013-09-04
717 reads
I will be presenting the session “Building an Effective Data Warehouse Architecture” today at 11am CST for the PASS DBA Fundamentals...
2013-09-03
912 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...
I have been reading SQLServerCentral for about 15 years and somehow never posted. This...
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...
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