On 29/08/2014 9:21 AM, Yong Huang (Redacted sender yong321@xxxxxxxxx for DMARC) wrote:
Reading Jonathan's blogs on SQL Server reminds me of Laimutis's old question: Why is SQL statement parsing a big issue to Oracle but not to SQL Server? //www.freelists.org/post/oracle-l/Any-reason-not-to-have-logic-in-the-db,17 That's a great question and I'd love to hear some comments.
It's the architecture Oracle decided on - they decided they wanted to share as much as possible to get scalability and avoid locking, and this was done in the day that memory was limited and we had 16 & 32 bit architectures.
On the other hand, explain why dirty reads and releasing locks was so important to SQL Server.