SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tag Maintenance Rss

Refine your search with one of the following additional tags (with number of items):

T-SQL (3)     Database Roles (1)     Indexes (1)     SQL 2005 (1)    
Administration (1)     index (1)     Security (1)     SQL Server 2005 (1)    
Automation (1)     Index Management (1)     SQL 2000 (1)    
   Items 1 to 7 of 7   
 

Move Physical Files

Script to move physical files to a new location  Read more...
By Jorge Novo 2008/05/30 | Source: SQLServerCentral.com | Category: Maintenance
Rating: (not yet rated) |  Discuss |  Briefcase | 4 reads

SQL Server 2005 Index Maintenance

Index maintenance procedure using rebuild or reorganized based on fragementation level.  Read more...
By Luke C 2008/05/29 | Source: SQLServerCentral.com | Category: Maintenance
Rating: |  Discuss |  Briefcase | 93 reads

Set Database to Single user

How to set the database to a single user mode  Read more...
By Jorge Novo 2008/05/20 | Source: SQLServerCentral.com | Category: Maintenance
Rating: (not yet rated) |  Discuss |  Briefcase | 5 reads

Identify Large Tables

Reports on physical size of tables in your database to identify largest.  Read more...
By Jesse McLain 2008/03/13 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 752 reads

Script a Database Role

Script one or all roles in a database. Includes users, obect permissions and column permissions.  Read more...
By Ed Vassie 2008/02/20 | Source: SQLServerCentral.com | Category: SQL 2000
Rating: |  Discuss |  Briefcase | 647 reads

Script foreign keys

Using this script you can create a list of sql commands for foreign keys manipulation.  Read more...
By Boka 2008/01/08 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 1,004 reads
   Items 1 to 7 of 7