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 favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 58    Older >>
 

Check Backups

Daily maintenance script to check on backups  Read more...
By Greg Ryan 2014/07/04 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 1,979 reads

Powershell script to report old backup files

Get a report of backups older than 60 days.  Read more...
By Rolando Hernandez 2014/05/30 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 785 reads

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,409 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 | 824 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 | 788 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,827 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 | 640 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 | 777 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,565 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,285 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,627 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 | 843 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 | 970 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 | 705 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,243 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,748 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,255 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,051 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,969 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,212 reads
   Items 1 to 20 of 58    Older >>