Canon 1D MII has a 8.0MP APS-H (28.7 x 19.1 mm ) sized CMOS sensor . On the other hand, Sigma Quattro H has a 45.0MP APS-H (26.6 x 17.9 mm ) sized CMOS (Foveon X3) sensor and features Dual TRUE III processor. Sigma Quattro H's sensor provides 37MP more than Canon 1D MII's sensor, which gives a significant advantage in real life. You can print your images larger or crop more freely.
On the other hand, please keep in mind that Max sensor resolution is not the only determinant of resolving power. Factors such as the optical elements, low pass filter, pixel size and sensor technology also affects the final resolution of the captured image.
Below you can see the 1D MII and Quattro H sensor size comparison.
As seen above, Canon 1D MII has a 1.2x Larger sensor area than Sigma Quattro H. Larger sensors give photographer more control on the depth of field and blurry background compared to smaller sensor when shot in same focal length and aperture.