It was never made clear why SGC never used the Wraith stunners after they made contact with Atlantis. After all, they're quieter than zats and can hit the same target several times without killing it. Perhaps "series stylistic differences". But in the Atlantis episode "Sadeta", made it make sense. The Sadatens had body armor that blocks Wraith stunners. What does this armor look very similar to? Jaffa armor. Turns out it actually does protect the user from something. Something only used in another galaxy, but still. The SGC won't standard-issue Wraith stunners because the chances of fighting a Jaffa (or possibly an Ori soldier) are very high, and the weapon could be useless.
On the other hand, Zats are able to both disable and kill and are a lot more compact than a weapon that can merely stun. While Wraith Stunners are cool, Zats are more effective.
SG-1 encountered a Bounty Hunter named Aris Boch in season 3 who had armour that was capable of blocking a kill shot from a Zat in a very similar way Ronan's armour blocked a Stunner. Clearly its easy enough to do with the right know how. In fact in another piece of Fridge Brilliance could be that both devices may share a similar mother weapon as both the Goa'uld and the Wraith have had plenty of opportunities to adapt some Ancient technology over the years.
For all that they are allies, the Tok'ra are awfully arrogant and heavy-handed with the Tauri. Then it hits you, they're still technically Goa'uld. Asshole is the Goa'uld hat. Evil is where the Goa'uld and Tok'ra differ.
However much O'Neill and the humans complain about the Tok'ra not telling them anything and taking advantage of them, and the Tok'ra being arrogant and stilted, when you think back you realize that the Tok'ra are constantly giving the Tauri information, helping them out and doing whatever they can to be there for them. There are very very few times the humans do the same, and only if they've got something to gain. They never are as selfless as the Tok'ra and are far more secretive and manipulative. This is something you only realise when you look back on their relationship as a whole.
When O'Neill's symbiote leaves him in "Abyss" it looks like it's trying to flee and betray him... it's only afterwards that you realise that leaving O'Neill would have killed the symbiote (he had nowhere to go and would have died out of O'Neill's body), but leaving O'Neill allowed him to claim innocence from the symbiote's actions and stop Baal from torturing him indefinitely for information on the Tok'ra. The symbiote stopped both Baal finding out about the Tok'ra by remaining in O'Neill and spared O'Neill a lot of pain. Comparatively.
The Tok'ra's glacially slow progress in their revolution makes a lot more sense when you remember that they're a Dying Race; no Egeria means every dead Tok'ra is irreplaceable. They're conservative and risk-averse because their every action is overshadowed by the fear that they could die out before they overthrow the Goa'uld, and for thousands of years as far as they knew if they failed the tyranny of the System Lords would continue forever.
Carter often calls O'Neill "colonel" instead of "sir" when speaking to him. In military culture, this is like calling someone by their first name, and O'Neill's allowance of it highlights the UST the pair have. Almost a Genius Bonus for military viewers.
Then again, this may be just an honest mistake.
With the tight relationship the series' production has with the real USAF, this is unlikely.
Definitely the UST, considering how they seem to have hooked up in every reality where Carter is not in the military.
Well, in the Air Force at least, it is entirely acceptable to refer to a superior by their rank, including abreviated forms for cases like calling a Lieutenant Colonel a Colonel. That said, it's faster just to say "Sir" or "Ma'am". Maybe calling him Colonel instead of "Sir" is just a light holdover from the borderline Straw Femenist version of Sam in the pilot, in this case, Sam preferring to use a gender-neutral form of address for a male superior.
Actually, she addresses him as "Sir" far more often than she ever says Colonel? It as even lampshaded in the episode when they lost their memories, when she's confused why she referred to him as "Sir", simply because it was a force of habit.
The Ancient Grome example in "Cor'ai", with Daniel confused that their native tongue would use both Latin and Greek for its root. My theory? The original settlers were harvested from pre-Roman Empire Italy, which contained Greek settlements. (We got the idiom "Pyrrhic victory" from a war fought between Greece and early Rome during this period, over these settlements.)
A justification for Explosions in Space when ships blow up. Most known spacefaring cultures use naquadah in their hull materials. Naquadah is known to be highly explosive under the right circumstances.
Why couldn't they name the Prometheus the Enterprise? Possibly due to the simple reason that the Navy still had a ship in service by that name (the nuclear-powered aircraft carrier USS Enterprise (CVN-65)) at the time.
"Nemesis" may have inadvertently patched a Plot Hole in the pilot, namely how Apophis et al. were able to dial back out of the SGC without the DHD (doubtful they could have figured out the dialing computer). In "Nemesis" SG-1 gates off the Beliskner by manually dialing using power left over from the last dial. Maybe that's what Apophis did.
At the end of Window of Opportunity it is said the Tok'ra have been trying to reach them for over three months. No set values are given, and we don't know when the Tok'ra began to try to contact Earth. With this, considering an average of 30 days to a month: 30(3 months)= 90 days. 90(24 hours)=2,160 hours. About ten or so hours per loop, so 2,160/10=216. Teal'c and O'Neill experienced a minimum of 216 loops, possibly many more.
In the Stargate SG-1 episode "Reckoning", a device is used which has the potential to destroy all life in the galaxy. It does this by activating all Stargates at once, and sending a certain signal. Since the Replicators were also destroyed in their home galaxy, we know this extends to the entire gate network. However, Stargate Universe reveals that this gate network is not limited to a few galaxies, but to a very large part of the universe. This means that not only can a device be built to end all life in a galaxy, but it can destroy all life that has ever existed in the universe. Not just the Goa'uld, Jaffa, humans, Asgard and lesser races, but every intelligent species in the entire universe. And any species which survives for 20 million years can build this sort of thing. The chance of nobody finding the same Phlebotinum in the entire universe is next to none. So even given the miraculous chance that nobody activated such a device yet, it's activation can't be far away. The death of every being in the entire universe is imminent, and can't be prevented. If our galaxy doesn't destroy the universe as we know it, one of the other 10^40 will.
While the Milky Way Stargate network clearly has a "branch" in the Ida Galaxy (possibly a retroactive plothole — shouldn't the Asgard 'Gate have looked different?), and we can assume the Pegasus gates were also affected if the dial-all-Gates program dialed all 8-chevron gate addresses, the 'Gates in Universe are (we can assume) all far enough away to require nine-chevron addresses to dial. Which, given the power requirements for dialing nine chevrons...I think it's safe to assume Dakara doesn't have a naquadriah core. So the universe is safe...probably.
As far as the Asgard gate looking the same as the Milky Way gates, the Stargate Wiki's theory is that the Pegasus gates are a later model with additional security features (no manual dialing, for one) to try and keep the Wraith out of the system. Ida didn't have that kind of threat floating around during the Ancients' active years.
You're forgetting something. The Asuran Replicators were initially subject to the same weakness as their Milky Way and counterparts before they adapted to the ARG, something the Dakara Superweapon was tuned too. Since they still exist in Pegasus after the deployment of the Daraka Superweapon, its safe to say that the Stargates affected by the weapon were limited to the Milky Way only. Also, remember the Asgard in the Ida galaxy were practically done. They were the predominant species there and they were nearly wiped out. The Replicators had taken everything they needed from them and thus had no need to remain in the Ida Galaxy anymore, turning their attention to the Milky Way. Thus even if the weapon had dialled the Ida Galaxy it would have been pointless.
Marduk's poor damn host. Hell, anytime a Goa'uld faces some sort of terrible fate or punishment while still in their host body.
While we're on the topic, the Tok'ra claim that any System Lord's host is going to be long since corrupted by sarcophagus addiction, so Daniel is doing them a favor by killing them instead of finding a way to free them. But we've seen Apophis' host emerge, and psychologically he seems all right in that respect (and thoroughly miserable and despairing).
At the end of "Fragile Balance", the young O'Neill turns out to be an Asgard-created clone of the original (who's still alive), but possesses all of his memories. He gets set up with a new identity, and decides to redo his high school years. Think about this for a second: He may look like a teenager, but he has the mind of a man in his mid-forties, and will be mingling amongst a bunch of 15-year olds, possibly even dating some of them. He's even shown getting an interested look from a bunch of high school girls.
On the other hand, it becomes downright tragic when you realise he's roughly the same age Charlie would have been. Damn...
Unfortunate Implications abound here but most guys don't lose their attraction to high school girls; they just realize that to do so would be either illegal or impractical. Why do you think one of the most common types of porn you can find on the internet involve actresses dressing up in school uniform?
How are people who follow NASA going to feel when they find out that while they have had to wait for years patiently for probes to get to the solar system planets to learn about them, Humans have been crossing interstellar distances in moments and didn't bother dropping off a probe on the way?
Really impressed that we now have hyperdrives.
NASA itself is already in on the Stargate Program. Remember how they sent the space shuttle Endeavor to rescue SG-1 and Bra'tac in the season 2 premiere? They also had a shuttle on standby in "Nemesis" to get SG-1 off the Beliskner.
If the Goa'uld larva in a Jaffa takes seven years to mature and Goa'uld can live for thousands of years, why don't the adult Goa'uld outnumber the Jaffa by a huge margin? This question is answered in "Summit".
Also the fact that since the Goa'uld fight among themselves a lot, a lot of larvae die with their Jaffa hosts.
Hell, this is probably why Goa'uld produce so many offspring.
The real problem is why they eat the larvae in the first place. They never once try to explain it.
Because the Goa'uld don't enjoy having competition. Eating the larva is essentially eliminating a future competing system lord. Which makes this Fridge Brilliance.