Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ben Seaman Optimising “Ends With” searches with REVERSE RE: Optimising “Ends With” searches with REVERSE
johnzabroski
SSCrazy
Points: 2355
More actions
January 13, 2010 at 11:42 am
#1103224
You can circumvent the max index key size
http://blogs.msdn.com/anthonybloesch/archive/2009/11/23/implementing-uniqueness-constraints-on-large-columns.aspx