A couple of weeks ago I was having issues tracking down a particularly confusing performance issue with Velowear.com. Since Velowear.com utilizes asp.net and webcom to work with the Ecometry order management system I could not use the built in Cassini web server to run and debug the web site. For the last two years I'd do all my coding on my own computer and upload the changes to a test server to see if everything would compile and run as expected. This worked ok, but it did not allow me to easily debug things, plus it was a pain if...
Background
Ecometry is the order managment system we use at Velowear.com (one of my responsibilities as Voler's IT Manager). Ecometry has many features for locating duplicates; but it does not include the ability to search through the entire customer data-set to find possible duplicates. Given this limitation I was assigned the task to find/merge duplicates using a third party tool (I was working for Velowear as a consultant at this time).
Details
I could not locate a third party tool so I decided to create my own system. Step one was to generate a view in SQL Server that would perform the heavy...