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

Getting Up and Running with Dapr

By

I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...

Data Platform products for Microsoft gaps

By

Microsoft has a ton of data platform-related products, but there are certain areas where...

Accessibility in font choice

By

Choosing the right typeface for your presentation (or for that matter anything you create...

Read the latest Blogs

Forums

Script to find session running SQL text and kill session

By caz100

Hi Looking for a  SQL script I can run as an agent job that...

Import Multiple Packages to SSIS server

By sagarSQLDBA

Comments posted to this topic are about the item Import Multiple Packages to SSIS...

need help on query

By abhas

Hi all, need help on below requirement. Thanks, Abhas

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers