SQLTeam.com | Weblogs | Forums

Select Into with partition



I know that is MSSQL PDW, we can CTAS a a new table with partition and index. How can i archive that with MSSQL 2014?



usually close enough:

INTO new table
FROM old table


yea select into is close enough.....but partition and index was not tag along =(


true, you'll have to wait for 2016 for that and add indexes later.