As a former wedding photographer, I typically went by the number of pictures I was willing to trust to a single card. Since file sizes went up at roughly the same time as storage sizes, I ratcheted up the maximum size SD card I'd use.

It used to be "won't use larger than 2GB". Right now it's around 8, but will likely become 16 in a couple of years.