(SQL) Tip of the Day: Improving Azure DW Insert Performance

Today’s Tip…

We have had a few cases recently with users concerned with their write performance on Azure DW. What we have found is that the backend distribution databases are designed for fast reading but can have some slower inserts. TempDB for Azure DW though uses very write efficient storage.

What we have found is that if you insert into a temp table first and then harden to your local table you will get significantly better write speeds and hopefully have a great experience with Azure DW!