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

Reflection on Talking at SQLSaturday Charlotte About Mental Health

By

On December 7, I did a session on mental illness and mental health problems...

A guide to acronyms, abbreviations, and other technical terms

By

Here’s a list of some technical terms, acronyms, and abbreviations you may have heard,...

T-SQL Tuesday #121: Gifts received for this year

By

At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve...

Read the latest Blogs

Forums

Querying Master Database DMVs in Azure SQL Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Querying Master Database DMVs in...

The Mangled Outer Join

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Mangled Outer Join

Is all transactions in one cursor treated as one transaction?

By Siqing LU

The client need to update a big table. the UPDATE will be done in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers