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

Content with tag Maintenance Rss

   Items 1 to 20 of 92    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,745 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 | 724 reads

Heaps rebuild

By Igor Micev 2014/05/21 | Category: heaps
Rating: (not yet rated) |  Discuss |   Briefcase | 1,602 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,600 reads

The Ultimate Index Lister (Non-Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. The non-pivot version also gives data type and other details for the columns.  Read more...
By Jesse Roberge 2013/10/02 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,558 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,377 reads

The Ultimate Index Width Stats Reporter

Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.  Read more...
By Jesse Roberge 2013/07/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,188 reads

The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)

Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.  Read more...
By Jesse Roberge 2013/07/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,585 reads

Custom Maintenance Plans - the T-SQL way

The non-SSIS/GUI method I use to deploy standardized Database Maintenance Plans.  Read more...
By Mark Marinovic 2013/05/16 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 3,151 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 | 823 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,041 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 | 785 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,805 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 | 639 reads

2008 Index Fragmentation Maintenance

Just a stab at automating index maintainenance in SQL Server 2008  Read more...
By Grant Fritchey 2013/01/11 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 2,490 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,207 reads

The Ultimate Missing Index Finder

Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.  Read more...
By Jesse Roberge 2013/01/07 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 18,484 reads

The Ultimate Index Usage Reporter

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.  Read more...
By Jesse Roberge 2012/12/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 7,441 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 | 769 reads

Find Mismatched Views and Stored Procs

Find missing and mismatched views and stored procs between 2 Databases  Read more...
By Pratap Prabhu 2012/09/03 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 1,513 reads
   Items 1 to 20 of 92    Older >>
 
Tags
administration (26)    
sql server 2005 (21)    
t-sql (21)    
indexing (20)    
maintenance and management (20)    
utility (16)    
performance tuning (11)    
automated dba (7)    
storage (7)    
sys.dm_db_partition_stats (7)    
backup / restore (5)    
list indexes (5)    
pivot (5)    
auto-growth (4)    
crosstab (4)    
data file management (4)    
for xml path (4)    
routine database growth (4)    
routine growth (4)    
sys.allocation_units (4)    
space usage (3)    
sql server 7 (3)    
automation (2)    
backups (2)    
buffer cache (2)    
database roles (2)    
fragmentation (2)    
lock and connection management (2)    
powershell (2)    
report (2)    
search (2)    
statistics (2)    
sys.dm_exec_query_plan (2)    
sys.dm_exec_requests (2)    
sys.dm_exec_sessions (2)    
sys.dm_exec_sql_text (2)    
sys.dm_os_buffer_descriptors (2)    
sys.partitions (2)    
troubleshooting (2)    
aggregates (1)    
alerts (1)    
archive (1)    
career (1)    
consulting (1)    
cursor (1)    
data integrity (1)    
data quality (1)    
database mail (1)    
dbcc checkdb (1)    
defragment (1)    
delete (1)    
development (1)    
disk space (1)    
duplicate indexes (1)    
dynamic management function (1)    
dynamic management view (1)    
dynamic sql (1)    
foreign keys (fk) (1)    
growth trend (1)    
heaps (1)    
html (1)    
indexes (1)    
kill connections (1)    
kill sessions (1)    
list scheduled jobs (1)    
log file maintenance (1)    
maintenance plans (1)    
management (1)    
missing indexes (1)    
old files (1)    
rebuilding indexes (1)    
reindex (1)    
resource planning (1)    
running aggregate (1)    
running totals (1)    
security (1)    
selectivity (1)    
space (1)    
sql server 2008 (1)    
staging (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
sys.dm_exec_connections (1)    
sys.dm_exec_cursors (1)    
sys.dm_tran_session_transactions (1)    
sys.foreign_key_columns (1)    
sys.foreign_keys (1)    
sys.sql_modules (1)    
system view (1)    
table variables (1)    
tuning (1)    
xp_cmdshell (1)