The FILESTREAM features is a new one in SQL Server 2008. It allows you to save a BLOB file on the physical hard disk instead of storing the binary data within the database (which results in large database file size). I have much tried out this new feature, but found an interesting article on Microsoft TechNet.
Thursday, June 11, 2009
Fuzzy Match / Grouping (Jaro Winkler)
Browsing through SQLServerCentral.com, I came across this artice regarding implementation of Fuzzy Matching and Grouping using Jaro Winkler method. Seems pretty promising. I am posting this for future reference.
Roll Your Own Fuzzy Match / Grouping (Jaro Winkler) - T-SQL
By Ira Warren Whiteside
Comparing Table Variables with Temporary Tables
I always get confused on whether to use Table Variable or Temporary Tables. Both seem to give similar functionalities. In some situations such as User-defined Function, you have no other option but to choose Table Variable.
Anyway, a good comparison on this would be great. I found this great article on SQLServerCentral.com by Wayne Sheffield comparing both method. Keeping it for future reference.
Subscribe to:
Posts (Atom)