This is a simple stored procedure, for inclusion in your script writing efforts, that strips non-numeric data from a given varchar. This is most usefull in scripts used to clean-up data such as account numbers that may include spaces, dashes and the like.
2004-09-21
227 reads
To help maintain index quality, defragging of any given index is a good thing. This will defrag ALL indecies in the current DB. NOTE: Schedule for off-hours operations. For a massive re-write of indecies, change the remarking on "--IF @indid" lines to use reindex instead of just defragging.
2004-09-21
554 reads
In the previous two posts on containers I showed how use Docker commands to...
I am delighted to announce that I have been selected to speak at the...
By Steve Jones
I was recently doing some work on Always Encrypted in SQL Server 2019 and...
Comments posted to this topic are about the item The Change Failure Rate
I found the article https://www.sqlservercentral.com/articles/bloor-scores-sql-provision-4-5-out-of-5-for-test-data-provisioning Interesting if a little shallow. It would be more...
...this is a 2nd attempt to post, as I can't seem to find the...
Ask SSC