No, I didn't know about Dwain's passing. I just wanted to give back since his code helped me come up with the solution to our issue. May more of us...

We were looking for a CTE based solution, but that proved to be far too slow. We ended up making this function, while very different, initially inspired by yours.

In our...

You have mostly 2 options.

* Use a couple cursors (lookup how to use cursors in BOL) to iterate your source table and the return from the SP (you can...

I haven't run data using both providers. My experiences with Google are from semi-manually running maps in Google Maps and Google Earth.

Yahoo seems more forgiving and to try harder...

Mike, as mentioned in other posts (and w/o trying to convert you, just trying to help with your legacy headache), one common mistake when using GUIDs is to cluster using...

I also declare myself ignorant, and read the article looking for a practical everyday application. Not that the article wasn't interesting and valid, it's just that you normally expect a...

Just a side comment. Depending on the purpose and expected lifetime of the application, you might have to deal with IPv6 addresses (http://en.wikipedia.org/wiki/Ipv6). In that case, you'd have...

I probably have made small changes since then. But a quick tests, and the TVF function seems to be working ok. The SP also seems to be working, however, the...

I also agree that making a CLR call from within a Trigger is a bit risky (your DBA probably won’t appreciate you doing this while he is away). With this...

NewSequentialId was interesting, but not being able to call it directly was a non-starter for us.

I found 2 implementations for NewSequentialID in an extended stored procedure, so you could use...

http://www.vmware.com/support/gsx3/doc/ha_configs_clusterbox_gsx.html

You can see VMWare instructions for GSX 3.2 for a "cluster in a box", they should apply to Workstation and to VMWare Server beta.

http://techrepublic.com.com/5100-1035_11-1058354.html

http://techrepublic.com.com/5100-1035_11-5034801.html

Step by step instructions...

I agree with bkelley. Setting up a standalone is a good way to work out any issues before adding clustering.

I'm not familiar with FreeTDS and UnixODBC, so I don't know...

I just came across this one myself. I imagine that by now you already have a solution, but I'm posting for the benefit of the next person to come across...

I recoded it as a TVF function. I modified the logic to return multiple matches, and did some code changes.

I used it to geocode 500 addresses, and it found 4...

This article came just in time. I used to work with address normalization and geocoding with a prior employer that had premium geocoding libraries available (like Group1 Centrus aka...