Re: SQL Server & MySQL

Hi Kyle

The Sql Server documentation is not a bad place to start and for a quick intro to SQL server and locking here is a starting point 1) . The handling of read consistency is dependent on the locking mod and how you have configured the database.
That is "read committed" behaved differently depending on database configuration.

1)
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/snapshot-isolation-in-sql-server

Best regards/Venlig hilsen

Peter Gram
Sæbyholmsvej 18 DK-2500 Valby

Mobile: (+45) 5374 7107
Email: peter.m.gram_at_gmail.com

<http://oaktable.net/members>

On Sun, 13 Feb 2022 at 17:54, kyle Hailey <kylelf_at_gmail.com> wrote:

>
> Does anyone know of any good books, websites that explain how SQL Server
> and MySQL manage read consistency, i.e creating point in time views of
> data? An explanation like the beginning of Jonathan Lewis' Oracle 8i Book
> would be greatly appreciated. I understand Oracle and Postgres read
> consistency but don't know MySQL or SQL Server.
>
> Thanks
> Kyle
>
>

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