Andrew Pruski shows off a new feature in SQL Server 2017:
Now I can run the SELECT…INTO statement using the new ON FILEGROUP option. I’m going to run an example SELECT statement to capture Sales in the UK: –
We are one step closer to CTAS on-prem… Being able to select into a specific filegroup is nice when you want to segregate tables by filegroup to make recovery of the most critical tables faster: having a primary filegroup, and then a filegroup for the critical tables for your application, followed by the history tables and other large tables that the app doesn’t need immediately.