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
244 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
557 reads
By Kamil
Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus...
There’s a really simple conundrum that we go through all the time. The best...
Comments posted to this topic are about the item Query Optimization Level
Comments posted to this topic are about the item Now Is a Good Time...
Hi everyone, I have a use case (below) for which I am considering multiple...
Ask SSC