Practical limits of resolution in confocal and non‐linear microscopy