I'm not claiming to be an expert in SQL, but the NOT operator not using a table scan really depends on what you're doing with it.
I fully expect NOT IN to use an index, for example.
I haven't really looked into the performance of OR vs. UNION. I rarely use OR, preferring to use IN instead on those few things that I actually need an OR for. I haven't studied the performance of IN vs. writing, say, 4 queries to check IPv4 masks, but I'm just going to assume IN will be faster.
Some of the sprite based games for the Playstation were great, too. Castlevania: Symphony of the Night in particular, although I supposed Alundra and Blood Omen: Legacy of Kain were fairly good as well.
All the other consoles always seemed to be tailored to children with fighting games, button mashing, racing games (I have a car, why would I want to drive one in a game??), etc.
It's funny that you should say that. Some of my favorite Playstation (1) games are: Castlevania: Symphony of the Night - 2D Side-scroller, the first "Metroidvania" title Alundra - 2D top-down adventure game, similar to Zelda 3 Metal Gear Solid - 3D top-down sneaking game, similar to (big surprise) Metal Gear Spyro the Dragon 1, 2, and 3 - 3D Platformers Lunar 2: Eternal Blue Complete - 2D RPG, remake of a Sega CD game Final Fantasy 9 - 3D RPG, and yes, 9 is not a typo
This isn't the complete list of games I own, but I can tell you this: I own at least 20 PS1 games, yet I don't own a single 3D Fighting game.
Just because you think a system is tailored towards one or two game types does not mean that there aren't other games available for the system.
First things first, I'm going to note that I hate skinned apps.
I hate that web browsers have gone the way of media players in the whole "we have to be skinned" point of view. If a user wants a skin for their app, I'm not going to say that it's a bad thing, but the default should resemble the windowing system's defaults.
Oh, before I forget, I use Opera with the Appearance changed to the native scheme for my OS.
"The issue of false positives were related to a single build of Cedega, so this affected only a subset of Cedega users." -- Tseric, Blizzard Poster, posted here.
That shell script looks suspiciously like the code to ucc (which found and ran ucc-bin) from the Unreal Tournament 436 linux dedicated server released by Loki back in 1999.
OK, this argument is confusing because the grandparent forgot to mention that the Telecoms are currently restricted from discriminating against companies because of their common carrier status. Current legislation means to change that, though.
In other words, Supporters != screw Google. Supporters are OK with traditional type-based QoS. Meaning that, if they want to screw Google, they have to screw all HTTP web traffic. Which is pretty much everything not using secure pages.
You will note, however, that this doesn't actually save MMO companies because they use unique ports.
In a sense, that is true. However, production of goods was affected in the US during wars not on its soil, as the workers were drafted and moved overseas.
They had to hire *gasp* WOMEN. This was, of course, back during the time when it was still unthinkable that women should actually work outside the home.
It's amazing how times change.
I am not, however, arguing the extent of the damage. Europe suffered far more heavily from the world wars than the rest of the world.
There is another really obvious point to be made, though: The United States is not the only country outside Europe. Its dominance is not solely because of its lack of losses in wars. China and India could have taken dominance, but they didn't. At least, we don't seem to consider them having the technological or economic lead.
Good point. I'm so used to thinking of it as a state... which it wasn't until 1959.
Back on the original subject, it depends on if you count terrorist attacks or not. The World Trade Center collapse, for instance, cost lots of lives and resources. So, in theory, that moves the year to 2001.
I wasn't originally going to read the article given the heavy Apple/Mac slant of the author's site, but there is one thing that really bugged me:
Frequently, the two parties partnering to deliver Windows PCs don't agree on details, or work at cross purposes. Microsoft can't force hardware makers to drop old legacy or adopt new technologies, and hardware makers can't force Microsoft to provide flawless support for unique hardware.
Yes, you're right.
However, on a heterogenous platform (Windows, for example), manufacturers write these things called "device drivers" that facilitate communications between the operating system and devices. In a homogenous environment (OSX, BSDs), the operating system manufacturer writes the device drivers. Linux is mostly along the lines of a homogenous environment, but lately companies like ATI and Nvidia are writing their own.
Since device drivers have more privileges than your ordinary program, Microsoft has a certification program for drivers, where they test them to make sure that they don't do bad things to the computer. If you try to install non-certified drivers, it pops up a dialog asking you if you're really sure that you want to install this.
Oh, that's right, this article is about Vista, not XP. In that case, 64-bit kernel mode drivers have to be signed or the OS won't load them. Period.
There is also a hidden argument here: Who should be responsible for the device drivers? The company who knows the OS or the company that knows the hardware?
In Gracenote's defense, grace note is a musical term and doesn't actually have anything to do with the actual word grace.
$0.50. You haven't used a pay phone in a while, have you? ;)
Yes, EXISTS is probably better than IN for subqueries, but the INs I work with now are more along the line of a small number of bound parameters.
I'm not claiming to be an expert in SQL, but the NOT operator not using a table scan really depends on what you're doing with it.
I fully expect NOT IN to use an index, for example.
I haven't really looked into the performance of OR vs. UNION. I rarely use OR, preferring to use IN instead on those few things that I actually need an OR for. I haven't studied the performance of IN vs. writing, say, 4 queries to check IPv4 masks, but I'm just going to assume IN will be faster.
Some of the sprite based games for the Playstation were great, too. Castlevania: Symphony of the Night in particular, although I supposed Alundra and Blood Omen: Legacy of Kain were fairly good as well.
I think that patent applicants should be required to make a working model before the patent can be granted.
It would solve a lot of the patent squatter problems...
I'm sorry, my mind is having trouble grasping the concept of someone named SQLGuru not using boolean operators.
I was just using it as an excuse to link to Bush looking stupid.
It's funny that you should say that. Some of my favorite Playstation (1) games are:
Castlevania: Symphony of the Night - 2D Side-scroller, the first "Metroidvania" title
Alundra - 2D top-down adventure game, similar to Zelda 3
Metal Gear Solid - 3D top-down sneaking game, similar to (big surprise) Metal Gear
Spyro the Dragon 1, 2, and 3 - 3D Platformers
Lunar 2: Eternal Blue Complete - 2D RPG, remake of a Sega CD game
Final Fantasy 9 - 3D RPG, and yes, 9 is not a typo
This isn't the complete list of games I own, but I can tell you this: I own at least 20 PS1 games, yet I don't own a single 3D Fighting game.
Just because you think a system is tailored towards one or two game types does not mean that there aren't other games available for the system.
You misquoted it! It's
"Fool me once
Shame on... shame on you.
If you fool me,
you can't get fooled again."
Oh, and don't forget the Sega Saturn, which launched 6 months earlier than developers expected it to.
First things first, I'm going to note that I hate skinned apps.
I hate that web browsers have gone the way of media players in the whole "we have to be skinned" point of view. If a user wants a skin for their app, I'm not going to say that it's a bad thing, but the default should resemble the windowing system's defaults.
Oh, before I forget, I use Opera with the Appearance changed to the native scheme for my OS.
"The issue of false positives were related to a single build of Cedega, so this affected only a subset of Cedega users." -- Tseric, Blizzard Poster, posted here.
That shell script looks suspiciously like the code to ucc (which found and ran ucc-bin) from the Unreal Tournament 436 linux dedicated server released by Loki back in 1999.
OK, this argument is confusing because the grandparent forgot to mention that the Telecoms are currently restricted from discriminating against companies because of their common carrier status. Current legislation means to change that, though.
In other words, Supporters != screw Google. Supporters are OK with traditional type-based QoS. Meaning that, if they want to screw Google, they have to screw all HTTP web traffic. Which is pretty much everything not using secure pages.
You will note, however, that this doesn't actually save MMO companies because they use unique ports.
NO WII?! YES WII!!
In a sense, that is true. However, production of goods was affected in the US during wars not on its soil, as the workers were drafted and moved overseas.
They had to hire *gasp* WOMEN. This was, of course, back during the time when it was still unthinkable that women should actually work outside the home.
It's amazing how times change.
I am not, however, arguing the extent of the damage. Europe suffered far more heavily from the world wars than the rest of the world.
There is another really obvious point to be made, though: The United States is not the only country outside Europe. Its dominance is not solely because of its lack of losses in wars. China and India could have taken dominance, but they didn't. At least, we don't seem to consider them having the technological or economic lead.
I choose you, Russiachu!
Wait, you mean I can blame this crappy style of government on another country?
Could you tell me which one so I can flame them to death?
Good point. I'm so used to thinking of it as a state... which it wasn't until 1959.
Back on the original subject, it depends on if you count terrorist attacks or not. The World Trade Center collapse, for instance, cost lots of lives and resources. So, in theory, that moves the year to 2001.
We don't lose people or resources in wars on other nations' soil?
P.S. Pearl Harbor is US soil, which bumps that year to 1941.
Man, if I didn't know better, I'd swear you were me.
Except that I wouldn't post anonymously.
So, it's OK to download music so long as you've never heard of the RIAA?
No, no, no... as everyone who has seen Avenue Q knows, the Internet is really, really great... for porn!
Yes, you're right.
However, on a heterogenous platform (Windows, for example), manufacturers write these things called "device drivers" that facilitate communications between the operating system and devices. In a homogenous environment (OSX, BSDs), the operating system manufacturer writes the device drivers. Linux is mostly along the lines of a homogenous environment, but lately companies like ATI and Nvidia are writing their own.
Since device drivers have more privileges than your ordinary program, Microsoft has a certification program for drivers, where they test them to make sure that they don't do bad things to the computer. If you try to install non-certified drivers, it pops up a dialog asking you if you're really sure that you want to install this.
Oh, that's right, this article is about Vista, not XP. In that case, 64-bit kernel mode drivers have to be signed or the OS won't load them. Period.
There is also a hidden argument here: Who should be responsible for the device drivers? The company who knows the OS or the company that knows the hardware?