Despite its steep licensing costs, SQL Server continues to prove its worth over open-source alternatives in some key areas.

Once you start making use of new features like SQL Server 2016’s in-memory updatable columnstores, those speed-ups could hit 100x for some types of queries.