Lock in SQL Server and Oracle [duplicate]Read Committed Snapshot Isolation vs Read Committed - pros and cons?FIFO queue table for multiple workers in SQL ServerCommit vs Fast Commit vs Commit Cleanout in Oracle DatabaseRefreshing Materialized view creates many child cursorsDetecting the locked table or row in SQL ServerCan I rely on reading SQL Server Identity values in order?Read Committed Snapshot Isolation vs Read Committed - pros and cons?Why SELECT query is waiting on HADR_SYNC_COMMIT?Strange Locking Behavior in SQL ServerOracle Database troubleshooting enq: TX - row lock contentionSQL Server Exclusive(X) lock not consistently blocking Shared(S) lock on a resource
I want to write a blog post building upon someone else's paper, how can I properly cite/credit them?
While drilling into kitchen wall, hit a wire - any advice?
What did Varys actually mean?
Make me a minimum magic sum
Why always 4...dxc6 and not 4...bxc6 in the Ruy Lopez Exchange?
In the figure, a quarter circle, a semicircle and a circle are mutually tangent inside a square of side length 2. Find the radius of the circle.
Do the Zhentarim fire members for killing fellow members?
A♭ major 9th chord in Bach is unexpectedly dissonant/jazzy
In a series of books, what happens after the coming of age?
Why did Gendry call himself Gendry Rivers?
How to get the decimal part of a number in apex
Scaling rounded rectangles in Illustrator
Appropriate age to involve kids in life changing decisions
Game artist computer workstation set-up – is this overkill?
Can anyone identify this unknown 1988 PC card from The Palantir Corporation?
Gift for mentor after his thesis defense?
Why were the rules for Proliferate changed?
How could a humanoid creature completely form within the span of 24 hours?
Why did Dr. Strange keep looking into the future after the snap?
How to make a kid's bike easier to pedal
My parents are Afghan
Why is the episode called "The Last of the Starks"?
Justification of physical currency in an interstellar civilization?
How does jetBlue determine its boarding order?
Lock in SQL Server and Oracle [duplicate]
Read Committed Snapshot Isolation vs Read Committed - pros and cons?FIFO queue table for multiple workers in SQL ServerCommit vs Fast Commit vs Commit Cleanout in Oracle DatabaseRefreshing Materialized view creates many child cursorsDetecting the locked table or row in SQL ServerCan I rely on reading SQL Server Identity values in order?Read Committed Snapshot Isolation vs Read Committed - pros and cons?Why SELECT query is waiting on HADR_SYNC_COMMIT?Strange Locking Behavior in SQL ServerOracle Database troubleshooting enq: TX - row lock contentionSQL Server Exclusive(X) lock not consistently blocking Shared(S) lock on a resource
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
This question already has an answer here:
Read Committed Snapshot Isolation vs Read Committed - pros and cons?
1 answer
I have been doing some tests of locking/blocking in MSSQL Server and Oracle, I noticed one difference:
In Oracle - I performed an update for one row without issuing commit or rollback and in another session I can view the underlying record, of course, I could view the last committed data and not the value that was yet to be committed.
In MSSQL Server - When I did the same operation in another session the SQL Server kept waiting for commit or rollback of the row that is getting updated.
Could somebody please explain locking mechanism between MSSQL server and Oracle.
sql-server oracle locking
edited Apr 28 at 17:45
Learning_DBAdmin
946217
asked Apr 28 at 16:41
Danilo NetoDanilo Neto
1615
marked as duplicate by mustaccio, marcello miorelli, kevinsky, hot2use, Mr.Brownstone May 2 at 19:53
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
add a comment |
This question already has an answer here:
Read Committed Snapshot Isolation vs Read Committed - pros and cons?
1 answer
I have been doing some tests of locking/blocking in MSSQL Server and Oracle, I noticed one difference:
In Oracle - I performed an update for one row without issuing commit or rollback and in another session I can view the underlying record, of course, I could view the last committed data and not the value that was yet to be committed.
In MSSQL Server - When I did the same operation in another session the SQL Server kept waiting for commit or rollback of the row that is getting updated.
Could somebody please explain locking mechanism between MSSQL server and Oracle.
sql-server oracle locking
edited Apr 28 at 17:45
Learning_DBAdmin
946217
asked Apr 28 at 16:41
Danilo NetoDanilo Neto
1615
marked as duplicate by mustaccio, marcello miorelli, kevinsky, hot2use, Mr.Brownstone May 2 at 19:53
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
4
You have hit on one of the fundamental differences between Oracle and MSSQL. In fact I believe this behavior of Oracle is unique to Oracle among all RDBMS products, and many would argue that this is a key reason they consider Oracle to be a superior RDBMS. Instead of trying to make a judgement on how you think it "should" be, or trying to make one behave like the other, it's better to simply adapt best practice for whatever rdbms you are working with. "When in Rome . . . "
– EdStevens
Apr 28 at 17:45
2
@EdStevens What's unique to Oracle? Postgressql uses MVCC and Sql Server has had snapshot isolation available as an optional setting since 2005.
– Martin Smith
Apr 28 at 22:11
@EdStevens Not forgetting Firebird!
– Vérace
May 2 at 17:43
add a comment |
This question already has an answer here:
Read Committed Snapshot Isolation vs Read Committed - pros and cons?
1 answer
I have been doing some tests of locking/blocking in MSSQL Server and Oracle, I noticed one difference:
In Oracle - I performed an update for one row without issuing commit or rollback and in another session I can view the underlying record, of course, I could view the last committed data and not the value that was yet to be committed.
In MSSQL Server - When I did the same operation in another session the SQL Server kept waiting for commit or rollback of the row that is getting updated.
Could somebody please explain locking mechanism between MSSQL server and Oracle.
sql-server oracle locking
edited Apr 28 at 17:45
Learning_DBAdmin
946217
asked Apr 28 at 16:41
Danilo NetoDanilo Neto
1615
This question already has an answer here:
Read Committed Snapshot Isolation vs Read Committed - pros and cons?
1 answer
I have been doing some tests of locking/blocking in MSSQL Server and Oracle, I noticed one difference:
In Oracle - I performed an update for one row without issuing commit or rollback and in another session I can view the underlying record, of course, I could view the last committed data and not the value that was yet to be committed.
In MSSQL Server - When I did the same operation in another session the SQL Server kept waiting for commit or rollback of the row that is getting updated.
Could somebody please explain locking mechanism between MSSQL server and Oracle.
This question already has an answer here:
Read Committed Snapshot Isolation vs Read Committed - pros and cons?
1 answer
sql-server oracle locking
sql-server oracle locking
edited Apr 28 at 17:45
Learning_DBAdmin
946217
asked Apr 28 at 16:41
Danilo NetoDanilo Neto
1615
edited Apr 28 at 17:45
Learning_DBAdmin
946217
asked Apr 28 at 16:41
Danilo NetoDanilo Neto
1615
edited Apr 28 at 17:45
Learning_DBAdmin
946217
edited Apr 28 at 17:45
Learning_DBAdmin
946217
edited Apr 28 at 17:45
Learning_DBAdmin
946217
946217
asked Apr 28 at 16:41
Danilo NetoDanilo Neto
1615
asked Apr 28 at 16:41
Danilo NetoDanilo Neto
1615
asked Apr 28 at 16:41
Danilo NetoDanilo Neto
1615
1615
marked as duplicate by mustaccio, marcello miorelli, kevinsky, hot2use, Mr.Brownstone May 2 at 19:53
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
marked as duplicate by mustaccio, marcello miorelli, kevinsky, hot2use, Mr.Brownstone May 2 at 19:53
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
4
You have hit on one of the fundamental differences between Oracle and MSSQL. In fact I believe this behavior of Oracle is unique to Oracle among all RDBMS products, and many would argue that this is a key reason they consider Oracle to be a superior RDBMS. Instead of trying to make a judgement on how you think it "should" be, or trying to make one behave like the other, it's better to simply adapt best practice for whatever rdbms you are working with. "When in Rome . . . "
– EdStevens
Apr 28 at 17:45
2
@EdStevens What's unique to Oracle? Postgressql uses MVCC and Sql Server has had snapshot isolation available as an optional setting since 2005.
– Martin Smith
Apr 28 at 22:11
@EdStevens Not forgetting Firebird!
– Vérace
May 2 at 17:43
add a comment |
4
You have hit on one of the fundamental differences between Oracle and MSSQL. In fact I believe this behavior of Oracle is unique to Oracle among all RDBMS products, and many would argue that this is a key reason they consider Oracle to be a superior RDBMS. Instead of trying to make a judgement on how you think it "should" be, or trying to make one behave like the other, it's better to simply adapt best practice for whatever rdbms you are working with. "When in Rome . . . "
– EdStevens
Apr 28 at 17:45
2
@EdStevens What's unique to Oracle? Postgressql uses MVCC and Sql Server has had snapshot isolation available as an optional setting since 2005.
– Martin Smith
Apr 28 at 22:11
@EdStevens Not forgetting Firebird!
– Vérace
May 2 at 17:43
4
4
You have hit on one of the fundamental differences between Oracle and MSSQL. In fact I believe this behavior of Oracle is unique to Oracle among all RDBMS products, and many would argue that this is a key reason they consider Oracle to be a superior RDBMS. Instead of trying to make a judgement on how you think it "should" be, or trying to make one behave like the other, it's better to simply adapt best practice for whatever rdbms you are working with. "When in Rome . . . "
– EdStevens
Apr 28 at 17:45
You have hit on one of the fundamental differences between Oracle and MSSQL. In fact I believe this behavior of Oracle is unique to Oracle among all RDBMS products, and many would argue that this is a key reason they consider Oracle to be a superior RDBMS. Instead of trying to make a judgement on how you think it "should" be, or trying to make one behave like the other, it's better to simply adapt best practice for whatever rdbms you are working with. "When in Rome . . . "
– EdStevens
Apr 28 at 17:45
2
2
@EdStevens What's unique to Oracle? Postgressql uses MVCC and Sql Server has had snapshot isolation available as an optional setting since 2005.
– Martin Smith
Apr 28 at 22:11
@EdStevens What's unique to Oracle? Postgressql uses MVCC and Sql Server has had snapshot isolation available as an optional setting since 2005.
– Martin Smith
Apr 28 at 22:11
@EdStevens Not forgetting Firebird!
– Vérace
May 2 at 17:43
@EdStevens Not forgetting Firebird!
– Vérace
May 2 at 17:43
add a comment |
1 Answer
1
active
oldest
votes
This is a default behavior of SQL server, to understand more you need to invoke isolation level. What you have described above falls in isolation level called "Read Committed". If you want similar behavior like Oracle in SQL server then you need to turn on the Read Committed Snapshot database option, basically this option takes a snapshot of your data before modifications and puts them in tempdb, accordingly you would see last committed record which was snapshot of last committed records. Another isolation level Read Uncommitted will in this situation return data but with a big catch i.e. you would read uncommitted records and there is a fair chance that you could read a dirty record.
There is concept of nolock and readpast as lock hint in SQL server for avoiding locking however it has its own impact.
You may read more about isolation level at Microsoft site at this link.
There are tonnes of article on this subject from many SME, I am listing few of them for your reference:
Brent Ozar --> https://www.brentozar.com/archive/2013/01/implementing-snapshot-or-read-committed-snapshot-isolation-in-sql-server-a-guide/
Kendra Little --> https://littlekendra.com/2016/02/18/how-to-choose-rcsi-snapshot-isolation-levels/
Erik Darling --> https://www.brentozar.com/archive/2018/01/heaps-deletes-optimistic-isolation-levels/
Paul White --> https://sqlperformance.com/2014/07/t-sql-queries/isolation-levels
Robert Sheldon --> https://www.red-gate.com/simple-talk/sql/t-sql-programming/questions-about-t-sql-transaction-isolation-levels-you-were-too-shy-to-ask/
There is a video from Brent Ozar (unable to find now) where he has clearly explained the difference between Oracle and SQL server you have mentioned. For this reason, Oracle used to cost lot more earlier than SQL server per core however now the case/scenario is different. One more thing to add here - In azure, RCSI is default behavior.
I hope above helps. Actually this is less of a question than a very important topic and understanding of SQL server and hard to cover them in one answer however above links will definitely guide you in right direction.
answered Apr 28 at 17:16
Learning_DBAdminLearning_DBAdmin
946217
4
Adding thatREAD_COMMITTED_SNAPSHOTis on by default in Azure SQL Database. The default behavior in on-prem SQL versions (locking instead of row versioning) is for backwards compatibility, IMHO.
– Dan Guzman
Apr 28 at 21:05
2
The licensing model and cost of the product is a pure commercial decision and has nothing to do with the technical implementation.
– Colin 't Hart
Apr 29 at 6:35
1
Sufficient to say it was once one of main justifications of Oracle's pricing, but it's history now.
– kubanczyk
Apr 29 at 7:45
1
Thanks for your valuable comments, I have edited my answer and removed pricing comparison.
– Learning_DBAdmin
Apr 29 at 9:04
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
This is a default behavior of SQL server, to understand more you need to invoke isolation level. What you have described above falls in isolation level called "Read Committed". If you want similar behavior like Oracle in SQL server then you need to turn on the Read Committed Snapshot database option, basically this option takes a snapshot of your data before modifications and puts them in tempdb, accordingly you would see last committed record which was snapshot of last committed records. Another isolation level Read Uncommitted will in this situation return data but with a big catch i.e. you would read uncommitted records and there is a fair chance that you could read a dirty record.
There is concept of nolock and readpast as lock hint in SQL server for avoiding locking however it has its own impact.
You may read more about isolation level at Microsoft site at this link.
There are tonnes of article on this subject from many SME, I am listing few of them for your reference:
Brent Ozar --> https://www.brentozar.com/archive/2013/01/implementing-snapshot-or-read-committed-snapshot-isolation-in-sql-server-a-guide/
Kendra Little --> https://littlekendra.com/2016/02/18/how-to-choose-rcsi-snapshot-isolation-levels/
Erik Darling --> https://www.brentozar.com/archive/2018/01/heaps-deletes-optimistic-isolation-levels/
Paul White --> https://sqlperformance.com/2014/07/t-sql-queries/isolation-levels
Robert Sheldon --> https://www.red-gate.com/simple-talk/sql/t-sql-programming/questions-about-t-sql-transaction-isolation-levels-you-were-too-shy-to-ask/
There is a video from Brent Ozar (unable to find now) where he has clearly explained the difference between Oracle and SQL server you have mentioned. For this reason, Oracle used to cost lot more earlier than SQL server per core however now the case/scenario is different. One more thing to add here - In azure, RCSI is default behavior.
I hope above helps. Actually this is less of a question than a very important topic and understanding of SQL server and hard to cover them in one answer however above links will definitely guide you in right direction.
answered Apr 28 at 17:16
Learning_DBAdminLearning_DBAdmin
946217
4
Adding thatREAD_COMMITTED_SNAPSHOTis on by default in Azure SQL Database. The default behavior in on-prem SQL versions (locking instead of row versioning) is for backwards compatibility, IMHO.
– Dan Guzman
Apr 28 at 21:05
2
The licensing model and cost of the product is a pure commercial decision and has nothing to do with the technical implementation.
– Colin 't Hart
Apr 29 at 6:35
1
Sufficient to say it was once one of main justifications of Oracle's pricing, but it's history now.
– kubanczyk
Apr 29 at 7:45
1
Thanks for your valuable comments, I have edited my answer and removed pricing comparison.
– Learning_DBAdmin
Apr 29 at 9:04
add a comment |
This is a default behavior of SQL server, to understand more you need to invoke isolation level. What you have described above falls in isolation level called "Read Committed". If you want similar behavior like Oracle in SQL server then you need to turn on the Read Committed Snapshot database option, basically this option takes a snapshot of your data before modifications and puts them in tempdb, accordingly you would see last committed record which was snapshot of last committed records. Another isolation level Read Uncommitted will in this situation return data but with a big catch i.e. you would read uncommitted records and there is a fair chance that you could read a dirty record.
There is concept of nolock and readpast as lock hint in SQL server for avoiding locking however it has its own impact.
You may read more about isolation level at Microsoft site at this link.
There are tonnes of article on this subject from many SME, I am listing few of them for your reference:
Brent Ozar --> https://www.brentozar.com/archive/2013/01/implementing-snapshot-or-read-committed-snapshot-isolation-in-sql-server-a-guide/
Kendra Little --> https://littlekendra.com/2016/02/18/how-to-choose-rcsi-snapshot-isolation-levels/
Erik Darling --> https://www.brentozar.com/archive/2018/01/heaps-deletes-optimistic-isolation-levels/
Paul White --> https://sqlperformance.com/2014/07/t-sql-queries/isolation-levels
Robert Sheldon --> https://www.red-gate.com/simple-talk/sql/t-sql-programming/questions-about-t-sql-transaction-isolation-levels-you-were-too-shy-to-ask/
There is a video from Brent Ozar (unable to find now) where he has clearly explained the difference between Oracle and SQL server you have mentioned. For this reason, Oracle used to cost lot more earlier than SQL server per core however now the case/scenario is different. One more thing to add here - In azure, RCSI is default behavior.
I hope above helps. Actually this is less of a question than a very important topic and understanding of SQL server and hard to cover them in one answer however above links will definitely guide you in right direction.
answered Apr 28 at 17:16
Learning_DBAdminLearning_DBAdmin
946217
4
Adding thatREAD_COMMITTED_SNAPSHOTis on by default in Azure SQL Database. The default behavior in on-prem SQL versions (locking instead of row versioning) is for backwards compatibility, IMHO.
– Dan Guzman
Apr 28 at 21:05
2
The licensing model and cost of the product is a pure commercial decision and has nothing to do with the technical implementation.
– Colin 't Hart
Apr 29 at 6:35
1
Sufficient to say it was once one of main justifications of Oracle's pricing, but it's history now.
– kubanczyk
Apr 29 at 7:45
1
Thanks for your valuable comments, I have edited my answer and removed pricing comparison.
– Learning_DBAdmin
Apr 29 at 9:04
add a comment |
This is a default behavior of SQL server, to understand more you need to invoke isolation level. What you have described above falls in isolation level called "Read Committed". If you want similar behavior like Oracle in SQL server then you need to turn on the Read Committed Snapshot database option, basically this option takes a snapshot of your data before modifications and puts them in tempdb, accordingly you would see last committed record which was snapshot of last committed records. Another isolation level Read Uncommitted will in this situation return data but with a big catch i.e. you would read uncommitted records and there is a fair chance that you could read a dirty record.
There is concept of nolock and readpast as lock hint in SQL server for avoiding locking however it has its own impact.
You may read more about isolation level at Microsoft site at this link.
There are tonnes of article on this subject from many SME, I am listing few of them for your reference:
Brent Ozar --> https://www.brentozar.com/archive/2013/01/implementing-snapshot-or-read-committed-snapshot-isolation-in-sql-server-a-guide/
Kendra Little --> https://littlekendra.com/2016/02/18/how-to-choose-rcsi-snapshot-isolation-levels/
Erik Darling --> https://www.brentozar.com/archive/2018/01/heaps-deletes-optimistic-isolation-levels/
Paul White --> https://sqlperformance.com/2014/07/t-sql-queries/isolation-levels
Robert Sheldon --> https://www.red-gate.com/simple-talk/sql/t-sql-programming/questions-about-t-sql-transaction-isolation-levels-you-were-too-shy-to-ask/
There is a video from Brent Ozar (unable to find now) where he has clearly explained the difference between Oracle and SQL server you have mentioned. For this reason, Oracle used to cost lot more earlier than SQL server per core however now the case/scenario is different. One more thing to add here - In azure, RCSI is default behavior.
I hope above helps. Actually this is less of a question than a very important topic and understanding of SQL server and hard to cover them in one answer however above links will definitely guide you in right direction.
answered Apr 28 at 17:16
Learning_DBAdminLearning_DBAdmin
946217
This is a default behavior of SQL server, to understand more you need to invoke isolation level. What you have described above falls in isolation level called "Read Committed". If you want similar behavior like Oracle in SQL server then you need to turn on the Read Committed Snapshot database option, basically this option takes a snapshot of your data before modifications and puts them in tempdb, accordingly you would see last committed record which was snapshot of last committed records. Another isolation level Read Uncommitted will in this situation return data but with a big catch i.e. you would read uncommitted records and there is a fair chance that you could read a dirty record.
There is concept of nolock and readpast as lock hint in SQL server for avoiding locking however it has its own impact.
You may read more about isolation level at Microsoft site at this link.
There are tonnes of article on this subject from many SME, I am listing few of them for your reference:
Brent Ozar --> https://www.brentozar.com/archive/2013/01/implementing-snapshot-or-read-committed-snapshot-isolation-in-sql-server-a-guide/
Kendra Little --> https://littlekendra.com/2016/02/18/how-to-choose-rcsi-snapshot-isolation-levels/
Erik Darling --> https://www.brentozar.com/archive/2018/01/heaps-deletes-optimistic-isolation-levels/
Paul White --> https://sqlperformance.com/2014/07/t-sql-queries/isolation-levels
Robert Sheldon --> https://www.red-gate.com/simple-talk/sql/t-sql-programming/questions-about-t-sql-transaction-isolation-levels-you-were-too-shy-to-ask/
There is a video from Brent Ozar (unable to find now) where he has clearly explained the difference between Oracle and SQL server you have mentioned. For this reason, Oracle used to cost lot more earlier than SQL server per core however now the case/scenario is different. One more thing to add here - In azure, RCSI is default behavior.
I hope above helps. Actually this is less of a question than a very important topic and understanding of SQL server and hard to cover them in one answer however above links will definitely guide you in right direction.
answered Apr 28 at 17:16
Learning_DBAdminLearning_DBAdmin
946217
edited Apr 29 at 9:03
answered Apr 28 at 17:16
Learning_DBAdminLearning_DBAdmin
946217
answered Apr 28 at 17:16
Learning_DBAdminLearning_DBAdmin
946217
answered Apr 28 at 17:16
Learning_DBAdminLearning_DBAdmin
946217
946217
4
Adding thatREAD_COMMITTED_SNAPSHOTis on by default in Azure SQL Database. The default behavior in on-prem SQL versions (locking instead of row versioning) is for backwards compatibility, IMHO.
– Dan Guzman
Apr 28 at 21:05
2
The licensing model and cost of the product is a pure commercial decision and has nothing to do with the technical implementation.
– Colin 't Hart
Apr 29 at 6:35
1
Sufficient to say it was once one of main justifications of Oracle's pricing, but it's history now.
– kubanczyk
Apr 29 at 7:45
1
Thanks for your valuable comments, I have edited my answer and removed pricing comparison.
– Learning_DBAdmin
Apr 29 at 9:04
add a comment |
4
Adding thatREAD_COMMITTED_SNAPSHOTis on by default in Azure SQL Database. The default behavior in on-prem SQL versions (locking instead of row versioning) is for backwards compatibility, IMHO.
– Dan Guzman
Apr 28 at 21:05
2
The licensing model and cost of the product is a pure commercial decision and has nothing to do with the technical implementation.
– Colin 't Hart
Apr 29 at 6:35
1
Sufficient to say it was once one of main justifications of Oracle's pricing, but it's history now.
– kubanczyk
Apr 29 at 7:45
1
Thanks for your valuable comments, I have edited my answer and removed pricing comparison.
– Learning_DBAdmin
Apr 29 at 9:04
4
4
Adding that
READ_COMMITTED_SNAPSHOT is on by default in Azure SQL Database. The default behavior in on-prem SQL versions (locking instead of row versioning) is for backwards compatibility, IMHO.– Dan Guzman
Apr 28 at 21:05
Adding that
READ_COMMITTED_SNAPSHOT is on by default in Azure SQL Database. The default behavior in on-prem SQL versions (locking instead of row versioning) is for backwards compatibility, IMHO.– Dan Guzman
Apr 28 at 21:05
2
2
The licensing model and cost of the product is a pure commercial decision and has nothing to do with the technical implementation.
– Colin 't Hart
Apr 29 at 6:35
The licensing model and cost of the product is a pure commercial decision and has nothing to do with the technical implementation.
– Colin 't Hart
Apr 29 at 6:35
1
1
Sufficient to say it was once one of main justifications of Oracle's pricing, but it's history now.
– kubanczyk
Apr 29 at 7:45
Sufficient to say it was once one of main justifications of Oracle's pricing, but it's history now.
– kubanczyk
Apr 29 at 7:45
1
1
Thanks for your valuable comments, I have edited my answer and removed pricing comparison.
– Learning_DBAdmin
Apr 29 at 9:04
Thanks for your valuable comments, I have edited my answer and removed pricing comparison.
– Learning_DBAdmin
Apr 29 at 9:04
add a comment |
4
You have hit on one of the fundamental differences between Oracle and MSSQL. In fact I believe this behavior of Oracle is unique to Oracle among all RDBMS products, and many would argue that this is a key reason they consider Oracle to be a superior RDBMS. Instead of trying to make a judgement on how you think it "should" be, or trying to make one behave like the other, it's better to simply adapt best practice for whatever rdbms you are working with. "When in Rome . . . "
– EdStevens
Apr 28 at 17:45
2
@EdStevens What's unique to Oracle? Postgressql uses MVCC and Sql Server has had snapshot isolation available as an optional setting since 2005.
– Martin Smith
Apr 28 at 22:11
@EdStevens Not forgetting Firebird!
– Vérace
May 2 at 17:43