DigitsOnlyEE and AlphaNumericOnly
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
2019-03-15 (first published: 2016-05-17)
2,718 reads
Michael Colling
PatReplace8K
This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.
2017-03-24 (first published: 2015-05-16)
2,137 reads
New T-SQL Fixed Width "Splitter"
A brand new tally table based, fixed width "splitter" that can be used for much more than just string splitting
2016-06-22 (first published: 2016-05-14)
1,812 reads
PatExclude8K
Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)
2016-06-10 (first published: 2014-10-27)
3,774 reads
Translate function for SQL Server
Relational database management systems such as Oracle, Postgres, DB2 and Teradata, as well as other programming languages such as Python, Hive, XSLT and SAS have a Translate function. Now we have one for SQL Server.
2016-06-01 (first published: 2016-05-12)
980 reads
Calculate Age (in years)
An inline table valued function (iTVF) that can be used to calculate age in years.
2016-04-27 (first published: 2016-04-06)
1,011 reads
Blogs
Announcing a New Book on SQL from 3Cloud Authors
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Identify the (Top 20) most expensive queries across your SQL Server using Query Store
Script to identify the most expensive queries on your database server using the Query...
Setting Up Always Encrypted
In this post we're going to go through the steps to set up Always...
Forums
Design Your Dream Festival poster with BrandFlex - Festival Poster
Are you looking for a convenient and hassle-free way to design eye-catching posters for...
TOP with Order By alternative, performance results look mixed
Hi I have a situation where I am testing two versions of the same...
Upgrading an Always on Availability Group two node from SQLServer 2016 to 2019
I'm looking for best practice here and these are Azure VMs by the way....
Ask SSC