Viewing 3 posts - 1 through 3 (of 3 total)
This was very helpful. Has anyone experimented with the percent clause?
I tried "select top 99.999 percent" and was able to get the result set I wanted - and it was...
November 16, 2006 at 9:20 am
#672349
One thing not mentioned is you can't index the VARCHAR(8000).
The maximum number of bytes in an index is 900.
-CN
August 23, 2006 at 6:05 pm
#656471
Yes, there are indexes on both.
The strange text is SQL Turbo related code - what they say to use - to find anything in the index that is like "sterilizes"....
October 12, 2005 at 2:15 pm
#596930