Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Filegroups Rss

   Items 1 to 10 of 10   
 

Dropping a Memory-optimized filegroup

By rhythm k 2014/06/09 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,248 reads

Filegroup for indexes

By Carlo Romagnano 2013/12/03 | Category: filegroups
Rating: (not yet rated) |  Discuss |   Briefcase | 1,820 reads

Find the size of all Indexes in a database

This script finds the size of all indexes in a database along with the table and the filegroup on which the index resides.  Read more...
By Bodhisatya Mookherjee 2013/10/15 | Source: SQLServerCentral.com | Category: indexes
Rating: |  Discuss |   Briefcase | 1,493 reads

T-SQL Tuesday #40– File and Filegroups

It’s the second Tuesday of the month and time for T-SQL Tuesday again. This is a monthly blog party, where...  Read more...
By Steve Jones 2013/03/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,545 reads

T-SQL Tuesday #40 - Proportional Fill within a Filegroup

T-SQL Tuesday #40 is underway, and this month's host is Jennifer McCown (blog|twitter).  The topic is about File and Filegroup...  Read more...
By Patrick Keisler 2013/03/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,391 reads

Move all SQL Server indexed views to a new filegroup

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.  Read more...
By Additional Articles 2013/02/11 | Source: MSSQLTips.com | Category: filegroups
Rating: (not yet rated)  Rate this |   Briefcase | 2,868 reads

Backup all Filegroups

A short script to backup all filegroups, for those who utilise filegroups within a database.  Read more...
By Richard Doering 2011/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,164 reads

Backup all Filegroups

A short script to backup all filegroups, for those who utilise filegroups within a database.  Read more...
By Richard Doering 2011/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,164 reads

Move one Filegroup to another

This script copies all tables found in a specific filegroup to another specific filegroup.  Read more...
By Tobias Kiemes 2009/08/19 | Source: SQLServerCentral.com | Category: filegroups
Rating: |  Discuss |   Briefcase | 1,298 reads

Using Partitioned Tables with Multiple Filegroups for High Availability

Let us look at another means to increase the availability of your highly critical databases. We will extend the concept of filegroups as highlighted in a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 2 (Isolating Critical Objects) wherein we can use filegroups to isolate and store a critical object.  Read more...
By Additional Articles 2008/11/20 | Source: MSSQLTips.com | Category: high availability (ha)
Rating: (not yet rated)  Rate this |   Briefcase | 2,750 reads
   Items 1 to 10 of 10   
 
Tags
administration (4)    
blogs (2)    
backup / restore (1)    
filestream (1)    
high availability (ha) (1)    
indexed views (1)    
indexes (1)    
memory-optimized tables (1)    
move (1)    
partitioned tables (1)    
size of indexes (1)    
storage management (1)    
t-sql (1)    
utility (1)