In a large bowl, combine mayonnaise, lemon juice, sugar, sour cream, onion and dill. Stir in shrimp. Cover and refrigerate overnight, stirring once.