The writing for this show is painful, the characters uninspiring and the acting embarrassing. And did they consult with any military personnel for advice on how the military actually conducts itself? Or military strategy? Not to mention the lousy costumes and special effects. The first episode was laughable and set the tone for as long as I could stomach it, hoping it would improve. The fact this series lasted ten seasons is a mystery I can only speculate relates to high numbers of the easily amused or ignorant. The original 1970's Battlestar Galactica was better done.
Firefly was twenty times better - writing and acting and characters - and that little gem was canceled after only one season. Battlestar Galactica was Shakespeare compared to Stargate, and they jumped ship after four seasons. The Star Trek series - TNG, DS9, Voyager - all light years ahead in terms of writing, characters and acting (even Worf) - yet each of these lasted only seven years. So for any "fan" of Stargate who equates "longest running" sci-fi series with "best", I suggest you check into sick bay for a hypo-spray of taste.