Turn of UAC also worked for me. I think safer than hotfix installs on live servers. You can turn it back on later

cheers

If you are happy to exclude index performance benefits or doing a like comparison you can create a computed column of the concatenation of other columns and then search the...

I really good performance improvement on string concatenation. I guess these problems weren't present in SQL 2000 so much as we didn't have 2GB varchar variables to work with and...