My answer would be is that it is because SQL is a declarative language. In SQL, you tell the system what you want, not how to do it. This means that the system can exploit any number of processers, memory etc to do the job.
I wouldn't want to single SQL Server out as being uniquely powerful. All well-developed RDBMSs have enormous power.