Hartshorne, Algebraic Geometry, Lemma II.5.3 reads (roughly):
Let $X = \operatorname{Spec} A$, let $f \in A$, and let $\mathscr{F}$ be a quasicoherent sheaf on $X$.
(a) If $s \in \Gamma(X, \mathscr{F})$ with $s|_{D(f)} = 0$ then $f^n s = 0$ for $n \gg 0$.
(b) If $s \in \Gamma(D(f), \mathscr{F})$ then $f^n s$ extends to all of $X$ for $n \gg 0$.
The proof essentially amounts to clearing denominators.
I'm trying to get a good picture of exactly what this is ruling out, but I don't have a great mental picture of a (obviously non-quasicoherent) sheaf where (a) and (b) don't hold. Are there any good examples to think of?
I never liked how Hartshorne presented this — my understanding is that the lemma says $\Gamma(D(f), \mathscr{F}) = \Gamma(X, \mathscr{F})_f$. There's always a map going left, and he shows (a) injectivity (b) surjectivity. This characterizes quasicoherence, so any non-quasicoherent $\mathscr{O}_X$-module should do.
Let's try a standard example of a non-quasicoherent ideal sheaf: $A = k[x]_{(x)}$ and $\mathscr{F}$ assigns $k(x)$ to the generic point and $0$ to the whole space. Then (b) fails with $f = x$.
I wish I had more intuition to offer you but non-quasicoherent sheaves seem pretty exotic to me since they appear to break out of the usual correspondence between geometry and algebra.