Re: oracle v SS

From: Powell, Mark <mark.powell2_at_dxc.com>
Date: Thu, 7 Nov 2019 21:09:15 +0000
Message-ID: <BL0PR01MB41163DB7B8C62AD61786B825CE780_at_BL0PR01MB4116.prod.exchangelabs.com>

It is also possible to configure SQL Server databases to use point in time consistent reads. See READ_COMMITTED_SNAPSHOT in the documentation. This feature reduces blocking, but the first release had a few performance issues.

One nice feature is you can include columns in an index that are not part of the key so changes in the column value result in an update to the index row rather than a delete insert as when the column is part of the key.

Mark Powell
Database Administration
(313) 592-5148

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Mladen Gogala <gogala.mladen_at_gmail.com> Sent: Thursday, November 7, 2019 3:43 PM To: oracle-l_at_freelists.org <oracle-l_at_freelists.org> Subject: Re: oracle v SS

On 11/7/19 3:13 PM, Orlando L wrote:

> Hi all
>
> Trying to decide between oracle and sql server for a query/warehousing
> type database. Can anyone share their input or point to a paper for
> the current versions. Thanks
>
> Orlando.

Hi Orlando!

SQL Server enterprise edition comes with what Oracle calls "In-Memory option" and partitioning, no further licensing required. SQL Server doesn't have multi-versioning which makes things simpler for mostly query database. On the flip side, readers block writers and vice versa, which means that loading usually means downtime. SS has something called "always on availability groups", which allows you to maintain shared nothing "cluster" with several identical database copies, which can be queried in parallel. SQL Server supports bitmap indexes and star (snowflake) schema queries. SQL Server EE is significantly cheaper than Oracle. I would advise going with SQL Server.

Regards

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l



DXC Technology Company - Headquarters: 1775 Tysons Boulevard, Tysons, Virginia 22102, USA.
DXC Technology Company -- This message is transmitted to you by or on behalf of DXC Technology Company or one of its affiliates. It is intended exclusively for the addressee. The substance of this message, along with any attachments, may contain proprietary, confidential or privileged information or information that is otherwise legally exempt from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate any part of this message. If you have received this message in error, please destroy and delete all copies and notify the sender by return e-mail. Regardless of content, this e-mail shall not operate to bind DXC Technology Company or any of its affiliates to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. --.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 07 2019 - 22:09:15 CET