DATASMITH Blog

0

UNION vs UNION ALL

In this post, we will have a look at the differences between UNION and UNION ALL operators using Heap and Clustered Tables. For this illustration, I will use the Adventure Works DW database. UNION – By default UNION does a distinct select on the valuesUNION ALL – Allows the selection...

8

How to Auto Schedule Data Export From Power BI

There always comes a time when you would like to export data whether it is usage statistics, performance or other data you would like to feed back into the BI system. In this post, you will see how to perform an automated data export using Power BI. Step by Step...

0

INSERT INTO vs SELECT INTO

Introduction What is faster to use… INSERT INTO or SELECT INTO? I have read many blog posts comparing INSERT INTO to SELECT INTO, yet so many still get it wrong. In this post, I will provide the full picture of performance differences between INSERT INTO and SELECT INTO and how...