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

Content with tag Maintenance Rss

<< Newer    Items 61 to 80 of 92    Older >>
 

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

The Ultimate Running Requests Reporter

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.  Read more...
By Jesse Roberge 2010/05/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,509 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

Deleting old files (with/without archive bit)

A hopefully useful script to delete old files, not just backups, and make use of the archive bit.  Read more...
By Gaby Abed 2009/01/01 | Source: SQLServerCentral.com | Category: archive
Rating: |  Discuss |   Briefcase | 1,825 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

Reindex all indexes online or offline depending on day of week.

This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.   Read more...
By Kenneth Singer 2011/04/18 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 4,391 reads

The Ultimate Connection Summarizer and Trouble Finder

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.  Read more...
Rating: |  Discuss |   Briefcase | 5,679 reads

Compare SQL code of 2 objects.

Compare SQL code of sp, functions, or triggers. Can run across DB and/or servers. Generates report similar to windif. See details in comments   Read more...
By llt 2008/10/31 | Source: SQLServerCentral.com | Category: maintenance
Rating: (not yet rated) |  Discuss |   Briefcase | 1,038 reads

The Ultimate Prospective-Index Column(s) Selectivity Analyzer

Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.  Read more...
By Jesse Roberge 2008/10/24 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,056 reads

The Ultimate Duplicate Index Finder

Searches database-wide for multiple indexes in the same table which has the same column as the first seek key. Optionally limits to LIKE wildcard patterns of table and schema names.  Read more...
By Jesse Roberge 2008/10/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,962 reads

disable/enable indexes for table

This procedure disables or rebuilds indexes for a given tablename  Read more...
By Wilfred van Dijk 2008/10/16 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,378 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

The Ultimate Index Lister (Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. This version outputs the member seek + include columns as two comma separated output columns.  Read more...
By Jesse Roberge 2008/10/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,405 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

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

Organizations With No DBAs

You have just been hired to help, "do database stuff", at a new company.  Read more...
By Sean Grinslade 2008/09/19 | Source: SQLServerCentral.com | Category: career
Rating: |  Discuss |   Briefcase | 12,946 reads

Check Fragmentation on All Indexes on Database

In this script we create a temporal table and then review all indexes with next conditions. avg_fragmentation_in_percent > 10 % or avg_page_space_used_in_percent > 90 %   Read more...
By Augusto Alfonso 2008/09/03 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,286 reads

The Ultimate Precompiled Procedure Searcher

Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.  Read more...
By Jesse Roberge 2009/10/08 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,849 reads

The Ultimate Foreign Key Researcher

Searches for actual and potential foreign key columns for a given primary key reference.  Read more...
By Jesse Roberge 2009/10/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,443 reads

Instance wide missing index

Database tables without primary key, clustered index and no index  Read more...
By Teshome Asfaw 2008/08/13 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 982 reads
<< Newer    Items 61 to 80 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)