Concatenating Two Database Tables Out-of-Memory with dplyr

Creating Custom Id Using the Concatenation of Three Columns in SQL Server with concat() vs concat_ws()