DRAG DROP -
You have a SQL Server 2012 database named DB1. DB1 contains four filegroups named FG1, FG2, FG3, and FG4. You execute the following code:
Two million rows are added to dbo.Sales.
You need to move the data from the first partition to a new table named SalesHistory and, starting on December 31, 2012, repartition dbo.Sales to support new sales data for three months.
Which code segment should you execute?
To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.
Select and Place:
Drag Drop You H 1 (56.12 KiB) Viewed 101 times
Drag Drop You H 2 (69.54 KiB) Viewed 101 times
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!