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
229 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
555 reads
By HamishWatson
So in January I wrote a blog post on some goals I had this...
By HamishWatson
This blog post is about a situation that initially perplexed me – I was...
By Devin-Knight
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I...
Gracious, and you may ponder—how'd things turn out with the bacon lovers? Their test...
Comments posted to this topic are about the item Changing Hardware
Ask SSC