usp_addcolumns
This is a stored procedure to add a columns to multiple tables, if column doesn't exist
2013-07-09 (first published: 2008-05-27)
968 reads
Scripts
Changing database mail account SMTP servers
This will generate a script that drops and recreates existing db mail accounts and change the smpt server.
2013-07-08 (first published: 2013-06-19)
815 reads
2013-07-03 (first published: 2013-06-07)
885 reads
Free space for all database files
I wrote this script to help determine which data files are taking up space on an instance.
2013-07-02 (first published: 2013-06-05)
1,597 reads
sp_wcProject
A stored procedure which provides wildcard column selections plus some additional bells and whistles
2013-07-01 (first published: 2009-01-28)
881 reads
2013-06-25 (first published: 2013-06-03)
1,560 reads
Locate a column across databases
This utility will locate a column across a subset or all databases across a server. Can be configured to run across versions, and can search tables, views or both.
2013-06-24 (first published: 2013-05-31)
1,238 reads
Reindexing for fragmented indexes
Script will give you the list of fragemented indexes.
(For SQL 2005-2008)
2013-06-21 (first published: 2013-05-31)
1,924 reads
Restore Script Generator
Create restore script from a SQL Backup file. A must have for your DBA Tool Belt.
2013-06-18 (first published: 2013-05-30)
2,308 reads
Re-Trust Untrusted Foreign Keys and Constraints
This script will attempt to re-trust untrusted foreign keys and will report counts of successes and failures.
2013-06-17 (first published: 2013-05-30)
1,149 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
25 Years Later: What SQLServerCentral Meant to Me
Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...
Doing Good at SQL Server Central
Comments posted to this topic are about the item Doing Good at SQL Server...
Question of the Day
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