tag:blogger.com,1999:blog-4394562672296169849.post5160436883437030722..comments2023-12-21T18:06:15.136+08:00Comments on class Programmer : IEnableMuch {: My musings on database deadlock issues part 2IEnableMuchhttp://www.blogger.com/profile/01393635235961303977noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4394562672296169849.post-76886143123036983762013-04-26T21:19:59.052+08:002013-04-26T21:19:59.052+08:00Nice to know you suggested Postgresql. That was th...Nice to know you suggested Postgresql. That was the database we're using in my old company, I love Postgresql it's very capable, e.g. http://www.anicehumble.com/2012/12/audit-trail-with-postgresql-hstore-data.html Plus it uses MVCC too. I spend about 4 years using Postgresql, its flexibility and features are very much advanced than what SQL Server can do<br /><br /><br />I'm now working in a company that uses SQL Server, and they are reluctant to turn on its MVCC(already present since version 2005, albeit not turned on by default). They think Microsoft can't vouch SQL Server 2008's MVCC capability, just because it is not turned on by defaultIEnableMuchhttps://www.blogger.com/profile/01393635235961303977noreply@blogger.comtag:blogger.com,1999:blog-4394562672296169849.post-86767623286732462932013-04-26T03:58:47.073+08:002013-04-26T03:58:47.073+08:00I have been dealing with deadlock issues since SQL...I have been dealing with deadlock issues since SQL Server 6.5 (know I'm sounding like grandpa...)<br /><br />Last year I had to develop a .NET project in PostgreSQL. I knew Oracle for long time, since 8.1 and it was pretty much the same concept here.<br /><br />When I tested a deadlock scenario I was more than happy to see how elegant PostgreSQL handles them. I encourage you to spend 2 hours with PostgreSQL and test for yourself, it works out of the box. I can't stress how great DBMS it is.<br /><br />Nice blog by the way. Cheers.Mauhttps://www.blogger.com/profile/15074790003292202726noreply@blogger.com