SQL Server 2000 Useful Undocumented Stored Procedures
In this article, Alexander Chigrik looks at some useful undocumented stored procedures that shipped with SQL Server 2000.
2008-10-17 (first published: 2001-10-08)
30,229 reads
In this article, Alexander Chigrik looks at some useful undocumented stored procedures that shipped with SQL Server 2000.
2008-10-17 (first published: 2001-10-08)
30,229 reads
This article examines how index statistics are used in SQL Server 6.5
2002-02-08
212 reads
Alxander Chigrik presents some useful User Defined Functions you can add to your SQL Server.
2001-12-19
8,643 reads
Alexander Chigriks decodes some SQL Server 2000 Undocumented System Tables.
2001-11-21
10,015 reads
A few stored procedures that are not documented in SQL Server 7.0, but may come in handy for DBAs
2001-11-07
7,989 reads
This article examines how index statistics are used in SQL Server 6.5
2001-10-30
3,316 reads
This article looks at some of the undocumented DBCC commands that exist in SQL Server 7.0
2001-10-22
7,544 reads
Alexander Chigrik presents a few UDFs he has developed for getting meta data about your database objects.
2001-10-17
4,107 reads
2001-10-12
3,587 reads
Alexander Chigrik presents a few Math UDFs he has developed for common functions.
2001-10-09
6,033 reads
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
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