SQLServerCentral: Content tagged Maintenance

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,699 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,602 reads

Check Candidate Columns for FOREIGN KEY Constraints

Reports table columns that are not foreign keys but that perhaps should be. Read more...

By Charles Jacobus 2013/04/23 | Source: SQLServerCentral.com | Category: maintenance |

SQL Scripts Manager Compatible

Rating: (not yet rated) |

Discuss |

Briefcase | 859 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,210 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 | 841 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: indexing

Rating:

|

Discuss |

Briefcase | 2,054 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 | 690 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,536 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,307 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 | 19,110 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,644 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 | 886 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,542 reads

2008 Index Rebuild using DMV

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information. Read more...

By Tommy Bollhofer 2012/08/09 | Source: SQLServerCentral.com | Category: indexing |

SQL Scripts Manager Compatible

Rating:

|

Discuss |

Briefcase | 1,606 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,342 reads

Developing Low-Maintenance Databases

Alex Kuznetsov's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take considerable time over meticulous database design, extensive constraints, automated tests, error logs, and defensive coding. Why? Because it cuts down on the subsequent need for maintenance. Read more...

By Additional Articles 2012/07/23 | Source: SimpleTalk | Category: maintenance

Rating:

Rate this |

Briefcase | 3,931 reads