Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Maintenance Rss

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

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,279 reads

Three Sample reports for the Automated DBA: Space Usage SnapShotter

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  Read more...
By Jesse Roberge 2009/07/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,389 reads

The Automated DBA: Batch Database File Grower - SQL 2000 Version

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.  Read more...
By Jesse Roberge 2009/06/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 558 reads

The Automated DBA: Batch Database File Grower - SQL 2005 Version

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.  Read more...
By Jesse Roberge 2009/06/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,148 reads

The Automated DBA: Batch Database File Grower - SQL2005 ReportOnly Ver

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.  Read more...
By Jesse Roberge 2009/06/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,026 reads

The Automated DBA: Batch Database File Grower - SQL2000 ReportOnly Ver

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.  Read more...
By Jesse Roberge 2009/06/19 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 564 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,662 reads

The Automated DBA: Space Usage Snapshotter Lite (non-sysadmin dbo)

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.  Read more...
By Jesse Roberge 2009/06/15 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,217 reads

Automate drive space monitoring for all production servers

Monitoring space in production server is one of the top priority tasks for a DBA. This script will automate it   Read more...
By Roshan Joe Joseph 2011/04/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,895 reads

Drop user statistics

This procedure drops all manually added statistics (field user_created=1)  Read more...
By Wilfred van Dijk 2009/06/11 | Source: SQLServerCentral.com | Category: maintenance
Rating: (not yet rated) |  Discuss |   Briefcase | 602 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,532 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,594 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,238 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: archiving data
Rating: |  Discuss |   Briefcase | 1,915 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,532 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,542 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,747 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,062 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,076 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 | 3,019 reads
<< Newer    Items 61 to 80 of 102    Older >>
 
Tags
administration (26)    
indexing (24)    
sql server 2005 (21)    
t-sql (21)    
maintenance and management (20)    
utility (16)    
performance tuning (11)    
automated dba (7)    
storage (7)    
sys.dm_db_partition_stats (7)    
backup and restore (5)    
list indexes (5)    
pivot (5)    
powershell (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)    
backups (3)    
space usage (3)    
sql server 7 (3)    
automation (2)    
buffer cache (2)    
database roles (2)    
fragmentation (2)    
lock and connection management (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)    
archiving data (1)    
blogs (1)    
career (1)    
consulting (1)    
cursors (1)    
data (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)    
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)    
plans (1)    
press release (1)    
purge (1)    
rebuild (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)    
stairway series (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 (1)    
table variables (1)    
tuning (1)    
xp_cmdshell (1)