Monday, July 29, 2013

optimize the query

Correct, the number of total bytes in the key can't be more than 900 if I recall well, so your only choice will be to let SQL Server do the sorting.


May be using the HASBYTES of those values. Check BOL fr more info about this function.




AMB


Some guidelines for posting questions...




No comments:

Post a Comment