Archive for the ‘Performance tip’ Category

How-to load data fast into SQL Server 2016 (2016-10-24)

What will be the absolute fastest way to load data from a flatfile into a table within SQL Server 2016? A lot has changed since my initial post on this topic many years ago, ike the introduction of In-memory optimized tables and Updateable Columnstore table indexes. Also the list of data transport vehicles to choose […]

APS Polybase for Hadoop and Windows Azure Blob Storage (WASB) Integration (2015-6-24)

Introduction The Microsoft Analytics Platform System (APS) comes with a very powerful feature that’s called Polybase. Polybase has been introduced over 2.5 years ago and extended ever since to integrate the world of structured and unstructured data, either on-premise as well in the Microsoft Azure cloud. The concept is simple: within an APS database you […]

Better Tag Cloud