I had a Sleep Number for just over year and after the novelty dissipated, I just couldn't take it anymore. I felt the individual air chambers and it wasn't comfortable at all.
I switched to a Tempurpedic in 2007 and couldn't be happier with it. It is as comfortable as the first night I slept in it.