In this Tip of the Week post, we will discuss how you can index a large data field to allow fast equality searching. What does this mean? It means that you won't be able to do indexed LIKE searches, but you will be able to do indexed = searches. Why is this necessary? This is necessary due to the size limitation of indexes in SQL Server. SQL Server does not allow you to create an index on any field, or combination of fields, whose length is greater than 900 bytes. For varchar fields, each character...