﻿<?xml version="1.0" encoding="utf-8"?><rss xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" version="2.0"><channel><title>SQLServerCentral.com Content tagged Maintenance and Management</title><link>http://www.sqlservercentral.com/</link><description>Content tagged Maintenance and Management posted on SQLServerCentral.com</description><language>en-us</language><ttl>360</ttl><managingEditor>sjones@sqlservercentral.com (Steve Jones)</managingEditor><item><title>SQL Server 2005 &amp; 2008 - Backup, Integrity Check &amp; Index Optimization</title><description><![CDATA[Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005 and SQL Server 2008. Updated 05 Sep 2009.]]></description><guid>http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/</guid><pubDate>2009/11/13</pubDate><link>http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/</link></item><item><title>View Errors in the Default Trace</title><description><![CDATA[Returns records with errors from the default trace ordered by most recent first]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/68648/</guid><pubDate>2009/11/12</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/68648/</link></item><item><title>The Ultimate Running Requests Reporter</title><description><![CDATA[Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL/66830/</guid><pubDate>2009/10/26</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL/66830/</link></item><item><title>The Ultimate Connection Summarizer and Trouble Finder</title><description><![CDATA[Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.]]></description><guid>http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/64433/</guid><pubDate>2009/10/22</pubDate><link>http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/64433/</link></item><item><title>The Ultimate Table Searcher Mk2</title><description><![CDATA[Searches for tables who's names contain the search string.  Gives Aggregate Size, Rows, Index, and Column information as well.]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/64870/</guid><pubDate>2009/10/20</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/64870/</link></item><item><title>The Ultimate Column Searcher</title><description><![CDATA[Searches for columns with names containing @Colname that belong to tables with names containing @TableName or schemas with names containing @SchemaName. Gives size and rowcount for tables.]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/63928/</guid><pubDate>2009/10/16</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/63928/</link></item><item><title>The Ultimate Index-Less Foreign-Key Finder</title><description><![CDATA[Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.<!-- NEW! Object recovery for SQL Server -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_OLR_Native/offers/try_olr_native.htm?utm_source=ssc&utm_medium=rss&utm_content=OlrNative_launch_200909&utm_campaign=sqlolrnative"><img alt="SQL OLR Native" height="68" src="http://www.red-gate.com/images/sql_server_central/olr_native_68x68.gif" width="68" border="0"/></a></td>
  <td><strong>NEW! Object recovery for SQL Server </strong><br />Recover individual database objects from native SQL Server<br> backups and restore them to any database. <a href="http://www.red-gate.com/products/SQL_OLR_Native/offers/try_olr_native.htm?utm_source=ssc&utm_medium=rss&utm_content=OlrNative_launch_200909&utm_campaign=sqlolrnative">Download a free trial </a><br>of Red Gate’s new SQL Object Level Recovery Native™.<img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>
]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/68357/</guid><pubDate>2009/10/15</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/68357/</link></item><item><title>The Ultimate Table Searcher</title><description><![CDATA[Searches for tables who's names contain the search string.  Gives Size and Rows information as well.]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/63929/</guid><pubDate>2009/10/14</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/63929/</link></item><item><title>The Ultimate Foreign Key Researcher</title><description><![CDATA[Searches for actual and potential foreign key columns for a given primary key reference.]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL/63509/</guid><pubDate>2009/10/12</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL/63509/</link></item><item><title>The Ultimate Precompiled Procedure Searcher</title><description><![CDATA[Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.]]></description><guid>http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/</guid><pubDate>2009/10/08</pubDate><link>http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/</link></item><item><title>The Ultimate Object Searcher</title><description><![CDATA[Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.<!-- NEW! Object recovery for SQL Server -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_OLR_Native/offers/try_olr_native.htm?utm_source=ssc&utm_medium=rss&utm_content=OlrNative_launch_200909&utm_campaign=sqlolrnative"><img alt="SQL OLR Native" height="68" src="http://www.red-gate.com/images/sql_server_central/olr_native_68x68.gif" width="68" border="0"/></a></td>
  <td><strong>NEW! Object recovery for SQL Server </strong><br />Recover individual database objects from native SQL Server<br> backups and restore them to any database. <a href="http://www.red-gate.com/products/SQL_OLR_Native/offers/try_olr_native.htm?utm_source=ssc&utm_medium=rss&utm_content=OlrNative_launch_200909&utm_campaign=sqlolrnative">Download a free trial </a><br>of Red Gate’s new SQL Object Level Recovery Native™.<img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>
]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL/68266/</guid><pubDate>2009/10/06</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL/68266/</link></item><item><title>The Ultimate PK-Less / CLIDX-Less Table Finder</title><description><![CDATA[Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/64880/</guid><pubDate>2009/10/02</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/64880/</link></item><item><title>SQL Server 2005 &amp; 2008 - Backup, Integrity Check &amp; Index Optimization</title><description><![CDATA[Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005 and SQL Server 2008. Updated 05 Sep 2009.]]></description><guid>http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/</guid><pubDate>2009/11/13</pubDate><link>http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/</link></item><item><title>Shrink Log File to Target Percentage</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/scripts/Maintenance/67988/</guid><pubDate>2009/09/23</pubDate><link>http://www.sqlservercentral.com/scripts/Maintenance/67988/</link></item><item><title>SQL Server 2005 &amp; 2008 - Backup, Integrity Check &amp; Index Optimization</title><description><![CDATA[Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005 and SQL Server 2008. Updated 05 Sep 2009.]]></description><guid>http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/</guid><pubDate>2009/11/13</pubDate><link>http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/</link></item><item><title>Shrink Log File to Target Percentage</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/scripts/Maintenance/67988/</guid><pubDate>2009/09/23</pubDate><link>http://www.sqlservercentral.com/scripts/Maintenance/67988/</link></item><item><title>SQL Server 2005 &amp; 2008 - Backup, Integrity Check &amp; Index Optimization</title><description><![CDATA[Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005 and SQL Server 2008. Updated 05 Sep 2009.]]></description><guid>http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/</guid><pubDate>2009/11/13</pubDate><link>http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/</link></item><item><title>Three Sample reports for the Automated DBA: Space Usage SnapShotter</title><description><![CDATA[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]]></description><guid>http://www.sqlservercentral.com/scripts/Admin/67437/</guid><pubDate>2009/07/13</pubDate><link>http://www.sqlservercentral.com/scripts/Admin/67437/</link></item><item><title>The Automated DBA: Batch Database File Grower - SQL 2000 Version</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL/67186/</guid><pubDate>2009/06/25</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL/67186/</link></item><item><title>The Automated DBA: Batch Database File Grower - SQL 2005 Version</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL/67185/</guid><pubDate>2009/06/23</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL/67185/</link></item><item><title>The Automated DBA: Batch Database File Grower - SQL2005 ReportOnly Ver</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL/67187/</guid><pubDate>2009/06/22</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL/67187/</link></item><item><title>The Automated DBA: Batch Database File Grower - SQL2000 ReportOnly Ver</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL/67188/</guid><pubDate>2009/06/19</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL/67188/</link></item><item><title>The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)</title><description><![CDATA[Records snapshots of space usage &amp; buffer cache usage stats by partition, index, table, schema, filegroup, &amp; database. Stats incl Reserved, Used, Data, buffer cache for row, lob, &amp; overflow.]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/67098/</guid><pubDate>2009/06/17</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/67098/</link></item><item><title>The Automated DBA: Space Usage Snapshotter Lite (non-sysadmin dbo)</title><description><![CDATA[Records snapshots of space usage stats by partition, index, table, schema, filegroup, and database. Stats include Reserved, Used, and Data for row, lob, and overflow.<!-- Free “SQL Server Tacklebox” eBook -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/sql_response/offers/response_tacklebox.htm?utm_source=ssc&utm_medium=rss&utm_content=ResponseAndBook200909&utm_campaign=sqlresponse "><img alt="SQL Server Tacklebox" height="68" src="http://www.red-gate.com/images/marketing/SSC/SQL_Server_Tacklebox_60px.gif" width="68" border=”0”/></a></td>
  <td><strong>Free “SQL Server Tacklebox” eBook</strong><br />
    <a href="http://www.red-gate.com/products/sql_response/offers/response_tacklebox.htm?utm_source=ssc&utm_medium=rss&utm_content=ResponseAndBook200909&utm_campaign=sqlresponse">Download the eBook</a> for expert advice on tackling<br>
SQL Server issues and try out SQL Response<br>
to be alerted to problems on your SQL Servers.<br>
<img src="/Images/spacer.gif?d=ad_resp1" /></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/67099/</guid><pubDate>2009/06/15</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/67099/</link></item><item><title>The Ultimate Running Requests Reporter</title><description><![CDATA[Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL/66830/</guid><pubDate>2009/10/26</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL/66830/</link></item><item><title>SQL Server 2005 &amp; 2008 - Backup, Integrity Check &amp; Index Optimization</title><description><![CDATA[Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005 and SQL Server 2008. Updated 05 Sep 2009.]]></description><guid>http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/</guid><pubDate>2009/11/13</pubDate><link>http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/</link></item><item><title>The Ultimate Index Width Stats Reporter</title><description><![CDATA[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.<!-- Exceptional DBA -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_Backup/offers/backup_how_to_become_exceptional_dba.htm?utm_source=ssc&utm_medium=rss&utm_content=BackupAndBook200909&utm_campaign=sqlbackup"><img alt="ExceptionalDBA" height="68" src="http://www.red-gate.com/images/marketing/SSC/EXDBA_V2_68px.gif" width="68" border=”0”/></a></td>
  <td><strong>Free “How to Become an Exceptional DBA (2nd ed.)” eBook</strong><br /><a href="http://www.red-gate.com/products/SQL_Backup/offers/backup_how_to_become_exceptional_dba.htm?utm_source=ssc&utm_medium=rss&utm_content=BackupAndBook200909&utm_campaign=sqlbackup">Download your copy</a> and a free trial of Red Gate SQL Backup for<br>
 robust SQL Server database backups.<br /><img src="/Images/spacer.gif?d=ad_bkup2" /></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL/65598/</guid><pubDate>2009/01/28</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL/65598/</link></item><item><title>The Ultimate PK-Less / CLIDX-Less Table Finder</title><description><![CDATA[Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/64880/</guid><pubDate>2009/10/02</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/64880/</link></item><item><title>Reindex all indexes online or offline depending on day of week.</title><description><![CDATA[This script will reindex  (online) any index eligible to be reindexed online.  Accepts a day of week parameter for full offline reindexing. ]]></description><guid>http://www.sqlservercentral.com/scripts/SQL+Server+2005/64530/</guid><pubDate>2008/11/12</pubDate><link>http://www.sqlservercentral.com/scripts/SQL+Server+2005/64530/</link></item><item><title>The Ultimate Connection Summarizer and Trouble Finder</title><description><![CDATA[Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.]]></description><guid>http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/64433/</guid><pubDate>2009/10/22</pubDate><link>http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/64433/</link></item></channel></rss>