It is Hamburg, Germany. Its the river "Elbe" and not the small Alster, and yes, great ships like the Queen Mary II can enter the harbour.
It amazes me every time that thousand of people are flocking to the Elbe just to see the QM2 entering or leaving the harbour.
Greeting from Hamburg
chris