phrase commonly used to say that something is leaking profusely when it is not supposed to leak at all. A sieve is a wire mesh or perforated metal utensil used for straining or sifting. Therefore anything that is leaking like a sieve is not holding water at all.
I have tons of water damage from the rain. My roof leaks like a sieve.