I have a fairly small table, approx 100,000 records. It has one ntext column, which has data ranging from 50k to 250k.
Doing a select for a fairly small number of records (using an index) that includes the ntext column, can take 30 seconds.
Help!
-Ken Williams