Filegroups

External Article

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

Leading Through Change: Guiding Teams in Times of Uncertainty

By

Change is not a disruption in technology; it is the rhythm. New frameworks appear,...

The Mystery of the Locked-Up Database -Scooby Dooing Episode 6

By

No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...

Announcements from the Microsoft Fabric Community Conference

By

A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...

Read the latest Blogs

Forums

food places in ontario ca

By bombaycuisine

Ontario, CA is home to a variety of restaurants, but when people talk about...

food places in ontario ca

By bombaycuisine

Ontario, CA is home to a variety of restaurants, but when people talk about...

Compatibility levels on database changing them and impacts.

By jonluder

We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...

Visit the forum

Question of the Day

Changing the Recovery Time

I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?

ALTER DATABASE Finance 
 SET TARGET_RECOVERY_TIME = 12 xxx;

See possible answers