Interesting Observation - Effect of Clustered Index over Nonclustered
posted by calebt(300) 3 years, 3 months ago 0
Not sure how useful this observation is since the example is only using 5 rows in the table. I imagine you'd see different behavior from the query optimizer if there were more rows in the table.
Reply
How to Integrate with Facebook Connect
Great article for getting started using Facebook Connect. I dug a little bit deeper and figured out how to use the .NET Facebook Toolkit with a logged in Facebook Connect user (making server side calls to the Facebook API instead of just javascript). http://stackoverflow.com/questions/323019/facebook-connect-and-asp-net/369691#369691
SQL Server Soundex Functions
posted by calebt(300) 2 years, 5 months ago 0
Check out the metaphone algorithm if you're working with English names. It produces much better results for names than soundex does: http://en.wikipedia.org/wiki/Metaphone