I'm guessing New Order - post Ancient download.

My favorite late season Daniel quote:

"Don't you ever give up?"

"Not until I'm dead... and sometimes, not even then." :)

Daniel has great snark lines, yes!

"What kind of archeologist carries a gun?"

(Daniel raises his hand)

"Uh, I do!"

And one of my favorites, in Fifth Race (sorry, kinda long here, and I copied-and-pasted it from an old post of mine):

When Sam and the others are trapped on the planet with two suns, several scientists are assigned to the problem. They describe their findings to Hammond, who turns and asks Daniel, “Do you understand what he just said?”

Daniel answers dryly, “It sounds like they have no idea.”

The scientist protests, “Well, actually it’s not ‘no idea,’ sir. Just… not much of one yet.” Another adds, “But we’re working on it!”

Later, when Jack has drawn his detailed diagram of the DHD, Daniel comes hurrying into the room where the scientists are, interrupting them with the news that Jack has the solution. As Hammond, Jack, and Janet rush to the control room, Daniel unceremoniously dumps Jack’s mysterious machine (I’ve seen it dubbed a mini-ZPM by SGA fans, and I personally find that hilarious) on the table in front of them.

“Here, you guys can work on that for a while.”

The scientists stare at it, and one asks, “What is it?”

Completely out of patience, Daniel hurries out of the room and calls over his shoulder, “No idea – well, not ‘no idea,’ just not much of one yet, but work on it!”

And then there's The Sentintel:

Kershaw says sneeringly, “I feel better just knowing there’s an archeologist watching our backs.”

Daniel holds up his knife and asks brightly, “Yeah. Which end do the bullets go in, again?”

Hee hee hee. Daniel!