Re: SQL Server & MySQL

Thanks for the links.

Oh this brings back memories of SQL Server's issues with the read/write blocking issues that SQL Server once had that I'd forgotten about.

I did a bunch of google searches on transaction consistency and wasn't turning up much. Looks like the key phrase is "row versioning"

Kyle

On Sun, Feb 13, 2022 at 9:40 AM Peter Gram <peter.m.gram_at_gmail.com> wrote:

> 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