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)
3,300 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,420 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,970 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)
4,571 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)
1,068 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,074 reads
Blogs
Walking Through a Planned Failover: SQL Server Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
Forums
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
What Power BI DirectQuery does to your SQL Server (and how to fix it)
Comments posted to this topic are about the item What Power BI DirectQuery does...
The New OS Wars
Comments posted to this topic are about the item The New OS Wars
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers