Sydney recorded its hottest November night as Australia's largest city suffered through a weekend heatwave that saw daytime temperatures peak above 40 degrees Celsius (104 degrees Fahrenheit).