Filegroups

Move all SQL Server indexed views to a new filegroup

  • Article

As databases grow, it often becomes necessary to add new I/O paths to accommodate the growing space. Even without growth that requires this scale, it can still be useful to utilize multiple I/O devices to spread out the load. One way that you can make optimal use of new drives is to add a filegroup to the database and move certain objects (say, all of your indexed views) to the new filegroup.

2013-02-11

3,176 reads

Blogs

Daily Coping 27 Nov 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 26 Nov 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Azure SQL Database – Greatest and Least TSQL

By

Being in the cloud does have many benefits, from lower administration to fast scaling...

Read the latest Blogs

Forums

Tlog migration

By Shree23

Hi Expert, In tlog migration, from 1 server to another where there is no...

RegisterAllProvidersIP = 0 and timeout in failover

By abdalah.mehdoini

Good morning all , I have an alwayson instance with a multisubnet listener I...

Tempdb increasing crazily

By 892717952

These days, the Tempdb of my one's SQL server increases crazily, sometimes only abount...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers