DigitsOnlyEE and AlphaNumericOnly
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
Michael Colling
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
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.
Calculate Age (in years)
An inline table valued function (iTVF) that can be used to calculate age in years.
GetNumsAB
A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.
PatReplace8K
This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.
PatExclude8K
Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)
Blogs
Drop Database Objects Practically Risk-Free!
FIRST OF A TWO PART SERIES Some months ago, a fellow DBA came to...
Lengthen a Primary Key–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Setup SQL Server Alert to get automatically notified of database blockings
By SQLPals
Suppose you want to or need to know anytime your SQL Server is experiencing...
Forums
Protecting Data Between Services
Comments posted to this topic are about the item Protecting Data Between Services
User Mapping Issues
I have a server that is version 12.0.6214.1 and here is my issue. I...
SQL browser and port number
We have several new servers running SQL 2014. Some servers are single instance servers...
Ask SSC