I love anything to do with the Asgard.
Thor was so adorable the first time they meet him and he says "I am the actual one whom you know as Thor"
Also love Vala/Daniel scenes
Cameron: Well either that or marry that chick
Vala: YEAH! Let's make BABIES!
The Fifth Race
Window of Opportunity
Teal'c "indeed" .. all indeeds.
Hammond of Texas (the character and the use of that title by Bra'tac)
"I am allowing the use of this ship because of the obvious tactical advantage it provides. Under NO circumstances is it to be used to travel through time."
And of course
Jack's fishless pond.
Yeah I always thought that was pretty crappy.