Removing double spaces in a string
Removes double spaces in a string, leaving all words seperated by a single space. Run in Query Analyzer.
2004-07-21 (first published: 2004-07-05)
231 reads
Counting ocurrences in a string
Counting the number of ocurrences of characters in a string can be useful, and this script will do the job. It can easily be modified to be a function or to search for ocurrences of strings. Run it in Query Analyzer.
2004-07-20 (first published: 2004-07-05)
134 reads
Blogs
When using Powershell to control Azure the Cloud Shell doesn’t require an additional login.
When studying Azure one of the things you’ll be asked to learn is the...
SQL Server Statistics Health Reminder
I’ve written about statistics in SQL Server a few times now. Through conversations I...
Running SQL Server containers as non-root
Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
Stairway to SQLCLR Level 2: Sample Stored Procedure and Function
Comments posted to this topic are about the item Stairway to SQLCLR Level 2:...
Database in Recovery Pending state
Good Morning, We had an issue yesterday where SQL Alerts were generated from one...
Ask SSC