This function will return the number of occurrences of one string within another string. I was looking for something like this recently, and the only thing I could find was needlessly complicated. Don't forget, when calling a scalar function, you must qualify with username like this:Select dbo.StringCount('Hi There','e') This function may be a little too […]
2004-03-09
273 reads
When you want to compare two strings that may have case differences on a case-insensitive server, this script will quickly and easily do the compare for you. It returns 0 if strings are equal, 1 if not. Feel free to modify/reuse in your code.
2003-02-11
181 reads
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
Comments posted to this topic are about the item How are statistics stored?
Comments posted to this topic are about the item Where's the Printer Friendly Option?
Using MSSQL 2019 standard edition It was installed using SVC Account. But now I...
How are the statistics for query optimization stored in SQL Server?
See possible answers