One of the jumpers on the motherboard must be set to jumperless in order for any of the bios settings to work (Except for dram frequency, which is always set in the bios.). None of the other adjustments will even be available in the bios after you take it off "jumperless", so this will be no problem. So technically, yes the dips override the bios settings.
Since you have a 900, you can't expect a miracle in the way of overclocking. If you've unlocked the CPU, you could get to around 1200, but expect more like 1000-1100mhz. This seems to be around the normal-top range for these CPU's. Some exceptional CPU's get up to 1400mhz, but imagine the cooling you'd need to keep it from burning up!! On the other end, I've had a couple not get more than 50mhz past their labeled speed.
Assuming you have unlocked the CPU- via the L1 bridges, try 9.5* 100 first. (remember that the 100 is CPU frequency, not dram frequency- that is set in the bios) Then up the multiplier one notch at a time until you get to the highest it loads windows at, or (unlikely)12.5. Then up the bus (via the dipswitches) one notch at a time until you reach the highest speed you can load windows at. (sometimes windows will load, but you get a registry checker error- turn it back down at this point) This will be your max. Along the way, you'll need to up the voltage via the jumpers near the CPU. 1.85v is the max. You will likely need this much to get very far.
Watch that heat. the temps reported in the bios aren't very accurate. Note the temp at labeled speed, and don't let it get out of hand.