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

Scripts with tag Maintenance Rss

Search for any content tagged maintenance

Get your favourite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 56    Older >>
 

Prevent DISK FULL when database grows

Get information to prevent DISK FULL when database grows.  Read more...
By Gonzalo Moles 2013/09/13 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 2,260 reads

Check Candidate Columns for FOREIGN KEY Constraints

Reports table columns that are not foreign keys but that perhaps should be.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 802 reads

Objects Referenced and Referencing

This script reports objects that are referenced by and that reference a given database object. When a column name is specified, it also includes results showing how that column is used.  Read more...
By Charles Jacobus 2013/03/07 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 767 reads

Script to Rebuild/Reorganise Indexes

A script to get the fragmentation of indexes in a database and then rebuild or reorganise accordingly  Read more...
By Andrew Pruski 2013/02/19 | Source: SQLServerCentral.com | Category: indexes
Rating: |  Discuss |   Briefcase | 1,759 reads

Check Candidate Columns for NOT NULL Constraints

This script reports table columns that allow NULL values but that currently have no NULL values, making them candidates for adding a NOT NULL constraint.  Read more...
By Charles Jacobus 2013/01/23 | Source: SQLServerCentral.com | Category: data integrity
Rating: |  Discuss |   Briefcase | 628 reads

Get Scheduled Jobs from Multiple Servers

Script to loop thru multiple linked server and get agent scheduled jobs for the next XX hours.  Read more...
By Dean Castro 2012/12/06 | Source: SQLServerCentral.com | Category: list scheduled jobs
Rating: |  Discuss |   Briefcase | 751 reads

2008 Index Rebuild using DMV

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.  Read more...
Rating: |  Discuss |   Briefcase | 1,543 reads

Finding Unused Database Roles

This is a data quality script that locates unused Database Roles for maintenance purposes  Read more...
By Brandie Tarvin 2012/07/24 | Source: SQLServerCentral.com | Category: database roles
Rating: |  Discuss |   Briefcase | 1,274 reads

Total Space Used for all databases per disk

Tells you how much the databases are using the space on disk taking in account the free space at the end of the database.  Read more...
By Gonzalo Moles 2014/01/08 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 3,539 reads

Auto compression all indexs on all online db

Auto compression of index, if index includes > 1 million rows.  Read more...
By Dmitriy Ivanov 2012/04/11 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 836 reads

Next grow for all databases per disk

This script lets you to know how much disk space will be left after the next database grow taking in account the free space left in the database.   Read more...
By Gonzalo Moles 2011/10/11 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 959 reads

List all tables without LOB columns

Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml). Useful when rebuilding indexes online.  Read more...
By SQLSACT 2011/08/30 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 697 reads

Index defrag script (21005/2008)

This script will allow reindexing (either rebuild or reorg)  Read more...
By Gregory Ferdinandsen 2010/08/25 | Source: SQLServerCentral.com | Category: reindex
Rating: |  Discuss |   Briefcase | 3,215 reads

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 2010/06/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,718 reads

Shrink Database Files in Size Increments

Auto shrink database files in size increment to a desired file size.  Read more...
By Boris Moyse 2010/03/02 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 2,199 reads

Identify Obsolete Indexes

Drop indexes no longer being used.  Read more...
By Chad Churchwell 2013/03/08 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,009 reads

Shrink Log File to Target Percentage

Performs a checkpoint or a transaction log backup followed by a DBCC SHRINKFILE on the transaction log to the target percentage specified relative to the total data file(s) size.  Read more...
By Tommy Bollhofer 2009/09/23 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 1,944 reads

Defragmenting and rebuilding indexes

Following code snippet will selectively rebuild indexes that have been thrashed after a big indert  Read more...
By Cool 2013/01/09 | Source: SQLServerCentral.com | Category: rebuilding indexes
Rating: |  Discuss |   Briefcase | 3,182 reads

Three Sample reports for the Automated DBA: Space Usage SnapShotter

1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot  Read more...
By Jesse Roberge 2009/07/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,290 reads

The Automated DBA: Batch Database File Grower - SQL2000 ReportOnly Ver

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.  Read more...
By Jesse Roberge 2009/06/19 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 551 reads
   Items 1 to 20 of 56    Older >>