Re: SQL Server & MySQL

Also try row lock escalation…

On Mon, Feb 14, 2022 at 5:49 AM kyle Hailey <kylelf_at_gmail.com> wrote:

>
> 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
>> <https://www.google.com/maps/search/S%C3%A6byholmsvej+18+DK-2500+Valby?entry=gmail&source=g>
>>
>> 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
>>>
>>> --

*Kellyn Gorman*
DBAKevlar Blog <http://dbakevlar.com>
about.me/dbakevlar

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