Soundex - Experiments with SQLCLR Part 3

Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework

Soundex - Experiments with SQLCLR Part 2

Constructive feedback on SOUNDEX - Experiments with SQLCLR lead to further experimentation with phonetic algorithms

SOUNDEX

How does SQL pronounce SQL?

Using SOUNDEX and DIFFERENCE to Standardize Data in SQL Server

My client wants to standardize address information for existing and future addresses collected for their customers, particularly the street suffixes. The application used to enter and collect address information has the street suffix separated from the address field, but it is a textbox instead of a drop down list therefore things are not standardized. I know there are some options out there to standarize data, but they would like a less expensive alternative. Are there any functions in SQL Server that I can use to standardized data?

RE: Managemanet Studio Package

Is it the Express Edition?If it is the case, you can download (free) the SQL Express Manager, but the SQL Server Management Studio is not deliver with this edition.Best regards,Carl

RE: Way forward??..

You only need SE for the branches. EE is required at the head office if you're going with a cluster. Keep in mind the cluster also require Windows 2000 Advanced Server or Windows 2003 Server Enterprise Edition for each node.

RE: Question of the Day for 23 Jul 2004

What about SELECT @@VERSION ?

RE: Question of the Day for 04 Jun 2004

Hi Mike,You said:... we can get either striped backup or 2 un-striped copies, depends which files we highlight.  How do you use the GUI to get 2 un-striped copies?  Although I never (never) use the GUI for backups, I thought that if you listed two files there, it always produced a striped backup?Hope all is well […]

RE: Cannot DESELECT Full Text Search component during custom install

I don't know why that didn't occur to me. Thank you!!!!!