March 17, 2009 at 12:13 am
I have few questions about SQL Server 2005 capabilty and would apprecaite, if someone please take a moment to answer:
1) Parallel execution: Does SQL 2005 supports parallel insert, update and delete feature?
2) Concurency model: Does SQL 2005 supports non-escalating row level locking and multi version read consistency?
3) Oracle supports Bitmap index which are ideal for Data warehouse. does SQL has anything similar?
4) Oracle also supports multi table insert and merge option. does SQL 2005 support these features?
Any update would be greatly apprecaited.
Many thanks,
March 18, 2009 at 4:00 am
Don't forget that SQL Server 2005 is 4 years old so I hope you are comparing to a 4-year old version of Oracle.
The answers are:
1) Yes. This is standard and the degree of paralelisation can be controlled by the MAXDOP setting.
2) Yes. See 'Snapshot Isolation' in SQL Server Books Online (BOL)
3) No. SQL Server has other types of index, some of which are unknown in Oracle. The main issue is if the processing is fast enough to meet the SLA, not how the procesing is done.
4) For SQL Server 2005 - No. For SQL Server 2008 - Yes see the MERGE statement in BOL.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 21, 2009 at 4:10 am
thanks for the contribution. indeed it helped and gave me lot of insight into sql features.
we are implementing a new data warehouse environment and the initial idea was to implement on oracle. given the economy and oracle expensive licenses, we started looking for alternatives and sql came to our mind. if sql can do the job, will go this route.
thanks again,
March 23, 2009 at 3:51 am
For a new installation, the best option is to use SQL Server 2008 64-bit on Windows 2008 64-bit (Or Windows 2003 64-bit if desperate). This will give you the best feature set and best performance and best long-term support.
You are bound to find some issues with SQL Server 2008, but you would also find issues if you use SQL Server 2005 or Oracle or DB2, etc. In my experience with the few bugs my colleagues have come across, Microsoft are good at responding to bugs in SQL Server, either with a fix or a workaround.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply