Tag: Databases
-
A good comparison of open source RDBMS
Here is a good comparison of open source RDBMS. This site also has a comparison of NoSQL databases.
-
A T-SQL SPLIT function
When taking existing data to put into a data warehouse one hopes that it is nicely formatted. This is seldom the case and recently I was faced with the problem that single field contained a rather dirty list. First I cleaned the list using REPLACE to replace the variety of delimiters with comma. Then I…
