I set it to 0, And please, could you answer the other question I asked?
On the above, you might want to check your baseline performance for a couple of days and then change it to MAXDOP 4 and do the same comparison. I've got 32 hyperthreaded processors and I had MAXDOP set to 8. Due to some extenuating circumstances, I had to change it to 4 for a while and, lo and behold, many of my larger runs cut their duration by 50%. It's worth the experiment.
I also have Cost Threshold of Parallelism set to 50 (for a long time).
As to your Full Text question, I'll have to bid a bye and let someone else answer that because I don't use Full Text Search anywhere.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)