Here's a quick and dirty function for parsing strings based on a delimiter (As in a varchar field with comma delimited text). I'm hoping for feedback on a more efficient means of doing this.Also,4 functions for comparing two delimited lists of strings. Many may ask why these are needed, but that's a very long explanation […]
2005-09-21 (first published: 2004-08-25)
253 reads
This is a utility proc that I use a lot for datawarehouse transformation/load processing. This is a generic proc for resequencing an integer column in sorted order within a given key combination.Note that 'key' is used here in a general context and not specific, that is there doesn't have to be any keys or indexes […]
2004-10-12
78 reads
Saw Mike's routine for counting occurences of a string in a string and I thought I'd offer a simpler solution.Simply replace the occurence with null and use length differences as shown.NOTE: len may ignore trailing spaces, so this can be made more solid by adding some non printable char (less likely to interfere with operation) […]
2004-03-10
66 reads
By Brian Kelley
If a technology is still viable, don’t overlook it. Don’t get caught up chasing...
By Steve Jones
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
Ancestral Ghost offers healing from family’s generational trauma through ancestral prayers, improving health and...
Comments posted to this topic are about the item Starting to Estimate Disk Storage...
Comments posted to this topic are about the item Keep. It. Simple.
If I have durable memory-optimized tables, what is the starting point for estimating storage space?
See possible answers