There's a fundamental difference between using SOUNDEX and using something like Levenshtein edit distance. I agree SOUNDEX is quite limited and other methods are much better, but other methods work...

Matt Miller (#4) (8/17/2011)

Don't read me wrong - it IS fast, it gains a LOT of efficiencies in those complex processes like I mentioned. And yes you can...

Matt Miller (#4) (8/17/2011)

---

Well the short answer is - its primary purpose isn't speed copies "as is" of data. There is a way to perform bulk-loading operations , but...

I...

@ Brian O'Leary

Please go back and read what I posted earlier in this thread and run the query I provided. I think I already showed where you may be mistaken.

The...

Where is the author? Where are the folks who defended the data collection query as harmless?

Steven993 said the query is fine. I think I have shown it's not fine.

Brian O'Leary...

I think the data aggregation query included in the article can produce wildly skewed results because of the bug in the data collection query. I think it could lead one...

Run the query below. It's a copy of the query in the article with two extra columns and an ORDER BY clause. You will very likely see rows where an...

I think the query as highlighted is an accurate representation. The effect of the problem is more than simply listing an index more than once, it can list an index...

Why is there not more concern being expressed when the query cited by peter-757102 (see page 1) is probably causing incorrect results from this tool? I posted a related query...

Steven993,

Are you sure the query cited by peter-757102 is fine? The object_id values are not unique across databases. When I run the query below I get numerous cases of the...