Tips
SQL Server User Defined Type To Store and Process Email Addresses
When stored as strings, email addresses sort by the user portion of the address instead of by the domain or the top level domain (TLD). That works for some applications, but in other applications queries would be faster if emails are stored in order by domain and TLD and easily searchable by those fields. In this tip I cover how to create a structure in SQL Server for indexing email addresses effectively.
Top 10
SQL Server User Defined Type To Store and Process Email Addresses
When stored as strings, email addresses sort by the user portion of the address instead of by the domain or the top level domain (TLD). That works for some applications, but in other applications queries would be faster if emails are stored in order by domain and TLD and easily searchable by those fields. In this tip I cover how to create a structure in SQL Server for indexing email addresses effectively.
Last 10
SQL Server User Defined Type To Store and Process Email Addresses
When stored as strings, email addresses sort by the user portion of the address instead of by the domain or the top level domain (TLD). That works for some applications, but in other applications queries would be faster if emails are stored in order by domain and TLD and easily searchable by those fields. In this tip I cover how to create a structure in SQL Server for indexing email addresses effectively.
