A bit hard to find through the search on Microsoft website, so here's the direct link:
You can easily move the table to another filegroup by recreate the clustered index on the table:
CREATE CLUSTERED INDEX CIX_YourTable ON dbo.YourTable(YourClusteringKeyFields) WITH DROP_EXISTING ON [filegroup_name]
If the clustered index is unique:
CREATE UNIQUE CLUSTERED INDEX CIX_YourTable ON dbo.YourTable(YourClusteringKeyFields) WITH DROP_EXISTING ON [filegroup_name]
This creates a new clustered index and drops the old one. Because the new index is created in the other filegroup, the table will have been moved to that filegroup.
|RTM (no SP)||SP1||SP2||SP3||SP4|
|SQL Server 2016||CTP 2.3|
|SQL Server 2014||12.0.2000.8||12.0.4100.1|
|SQL Server 2012||11.0.2100.60||11.0.3000.0|
|SQL Server 2008 R2||10.50.1600.1||10.50.2500.0|
|SQL Server 2008||10.0.1600.22||10.0.2531.0|
|SQL Server 2005||9.0.1399.06||9.0.2047||9.0.3042||9.0.4035||9.0.5000|
|SQL Server 2000||8.0.194||8.0.384||8.0.532||8.0.760||8.0.2039|
|SQL Server 7.0||7.0.623||7.0.699||7.0.842||7.0.961||7.0.1063|
* Alternate version numbers.
When restoring a database, you usually start with restoring a full backup, then any differentials, and finally the transaction logs. You set the database restore mode to WITH NORECOVERY, which allows you to perform these additional restores.
But what if you find out that there's nothing more to restore, leaving you with a database stuck in Restoring mode? Then you only need to run a single T-SQL statement:
RESTORE DATABASE [db_name] WITH RECOVERY
Replace db_name with the name of your database.
Follow the chart below to successfully perform a rolling upgrade of your HA SQL Server cluster.
If, when attempting to start SQL Server instance, you get an error 1814, this means there's a problem with the tempdb database. Either it can't be created because the disk or volume is not accessible for writing (i.e. a security permission problem), or the volume on which the tempdb resides does not have enough space available. If the latter is the problem, you'll need at least 2 MB of free space for tempdb to be created.