News for hackers. Stuff that matters.
Re:Microsoft SQL Server 2016 Express by dccoolgai on Wednesday October 12, 2016 @07:18AM (#12691894)
Also, SQL Server gets you some pretty nice benchmarks virtually out of the box. You can beat it on PostGres sometimes, but only after considerable configuration/optimization. And, like you said, the toolchain. SQL Studio will spoil you.
Re:Microsoft SQL Server 2016 Express by serguzest on Wednesday October 12, 2016 @10:27AM (#12693127)
Correct me if I am wrong, MS Sql server isn't true MVCC database and there is some support and it is not default, you have to set READ_COMMITTED_SNAPSHOT ON for the database. They implemented it in 2005. Most microsoft shops don't bother to develop their softwares for this, they are using archaic locking transactions. I've seen many Sql Server deployments keep choking on locking transactions and and people are buyin bigger servers, more Windows and Sql Server licences for each cpu/core to deal with their choked database server.

So while Postgresql's defaults are all about technical concerns, Sql server's defaults are just convenient for Microsoft sales team.

Re:Microsoft SQL Server 2016 Express by AaronFriel on Wednesday October 12, 2016 @11:51AM (#12693929)
Both are true! MS SQL Server is a "true MVCC" database (no-true Scotsman?) and you are correct. SQL Server supports snapshot/MVCC isolation for transactions, but it must be enabled. They are determined to maintain 20 years of backward compatibility, and while I think that's wrong, they leave snapshot isolation disabled by default.

https://msdn.microsoft.com/en-us/library/ms173763.aspx

Re:Microsoft SQL Server 2016 Express by serguzest on Wednesday October 12, 2016 @12:51PM (#12694470)
It uses tempdb for tracking versions, it is not true mvcc in the engine.
Re:Microsoft SQL Server 2016 Express by br1 on Wednesday October 12, 2016 @02:14PM (#12695250)
That's an internal detail. It's much cleaner than postgresql that leaves old tuples in disk and has to vacuum them later.
Re:Microsoft SQL Server 2016 Express by greggyb on Wednesday October 12, 2016 @05:39PM (#12696609)
It also offers an optimized in-memory transactional engine that is lockless and compiles stored procedures to native code.
Re:Microsoft SQL Server 2016 Express by kbenson on Wednesday October 12, 2016 @11:11AM (#12693565)
I can't comment on whether this is correct, but on the MSSQL box I integrate with, lock contention and the server automatically killing deadlocked queries is a regular occurrence. Like 50+ times a day regular.
Re:Microsoft SQL Server 2016 Express by WayneBro on Wednesday October 12, 2016 @03:57PM (#12695981)
You also get SSDT with SQL Server. PG has nothing like it - https://msdn.microsoft.com/en-us/library/hh272686(v=vs.103)....