A Procedure gather Server Statistic per day or per run this Procedure.Output: Table TBL_SERVERSTATISTICS. You can use the results to analyze SQL-Server performance problems. You can analyze what changed after install new hardware or software, add or remove Application/DB/File/Index/Table etc.Recommendations: Run a Procedure once every day.Warning: If sql-server restarted after last run a Procedurecurrent running […]
2003-03-13
1,059 reads
A procedure send message to all active SQL Server users(SQL Server Connections) on your Server.I use Win command NET SEND.
2003-02-25
539 reads
A Procedure send Alert by E-Mail about allfiles with option "Restrict File Growth" ifavailable space less then 10%.
2003-02-24
325 reads
When log_file bigger then data_file you will getReport by E-Mail.For ALL DB.
2003-02-20
172 reads
A Procedure build Report about NEW and Deleted DB.First time you must to run p_build_check_db.This procedure build table master..t_databases same asmaster..sysdatabases .Procedure p_check_db compare t_databases and sysdatabases and send a report to your@E-MailAddress.Best regards. Vadim.
2003-02-20
168 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...
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