ak3ldama's Journal: Microsoft SQL Server

This is just a small update on the sql training. MS SQL Server isn't really all that bad, and my sql knowledge in general has improved slightly but it was mainly a refresher on things. Which is of itself good since it's so easy to space off or partially forget this stuff when you don't deal with it every day. The main thing that I notice is that there is so much stuff that is only available with Enterprise which is like, $20K per processor or something like that. One such thing is an Index on a View, another would be online index adjustments. Here is one comparison list.

There are a lot of XML features which is incredibly wierd since XML in SQL is fundamentally wrong. SQL doesn't allow arrays as an entry, so why XML? It is as if they bent over backwards for XML when at least theoretically they should've said no. (Strings don't count.) This array issue is even discussed early on in Joe Celko's SQL for Smarties.

Re:

[Jeremiah Cornelius]

Mindblowing vertical scaling and transaction speed?

If you need 'em, you pay.

Re:

[ak3ldama]

haha, thanks. I thought about replying to the AC. I am pretty sure it has most of the things he wined about and you can basically accomplish the 'row level trigger'. It has plenty but what is nice is the tools. Sure no one uses Microsoft's compilers at a command line - its the tools that everyone likes. I think the same applies with SQL Server, alone the server is merely competitive and maybe above average; but the tools help it a lot.

Re:

[Jeremiah Cornelius]

There are DB uses that really do look at TPM and the like. Somehow, amazingly, Microsoft is trouncing Oracle.

There's no way they could get the per-proc cost they ask, if they were "also-ran".

For licensing, MSFT also count dies, not cores. I don't know about current ORCL sales, but they used to count a dual-core as 2 CPUs for sales. On the new quad-cores, this goes to OUCH. But ORCL is also thowing blanket-pricing "all-you-can-eat" deals at customers. This is to keep their incumbent position through dea

Re:

[ak3ldama]

That doesn't mean shit for the large numbers of 'microsoft shops' out there with countless developers that are happy with the microsoft tools, documentation, and training. On the level of helping their developers/users microsoft 'usually' does a good job, regardless of their other problems. I understand your argument, and for many people it is valid; but there are a lot of people who don't care about raw performance on 'that' level.