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

Content with tag Maintenance Rss

   Items 1 to 20 of 102    Older >>
 

Check Backups

Daily maintenance script to check on backups  Read more...
By Greg Ryan 2016/02/05 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 3,084 reads

Backup File Inventory

Are you using Ola Hallengren's Maintenance Solution? Here's a Python script that helps you keep track of your backup file inventory.  Read more...
By Joel Askey 2016/01/25 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 2,067 reads

PoSh Index Rebuilds

By Steve Jones 2016/01/04 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,213 reads

Stairway to SQL PowerShell Level 11: SQL Server Maintenance Using SQL PowerShell

This level will demonstrate simple techniques to perform a few important SQL Server maintenance tasks using PowerShell. We'll barely scratch the surface of what's possible but I hope it will whet your appetite.  Read more...
By Ben Miller 2015/12/16 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,602 reads

Prevent DISK FULL when database grows

Get information to prevent DISK FULL when database grows.  Read more...
By Gonzalo Moles 2015/10/19 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 4,168 reads

A general way to maintain History tables

You will see here a way to handle history tables. This way only takes into account Date-based data cleanup but is easily generalizable.  Read more...
By Jefferson Elias 2015/09/28 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 7,877 reads

Scheduling Ola Hallengrens Maintenance Solution Default Jobs with Powershell

If you are a SQL Server DBA you should know about Ola Hallengren and will probably have investigated his Maintenance...  Read more...
By Rob Sewell 2015/05/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,554 reads

The Real World: Rebuilding Index - 1 Instance, 106 Databases

The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.  Read more...
By Kenneth Igiri 2015/02/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,045 reads

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 2015/02/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,836 reads

The MidnightDBAs release Minion Reindex

The MidnightDBAs have developed a free reindexing solution to help DBAs perform maintenance on their instances. Read about the solution and attend their webinar.  Read more...
By Press Release 2014/10/24 | Source: SQLServerCentral.com | Category: press release
Rating: |  Discuss |   Briefcase | 1,979 reads

Check Backups

Daily maintenance script to check on backups  Read more...
By Greg Ryan 2016/02/05 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 3,084 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 | 946 reads

Heaps rebuild

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

Prevent DISK FULL when database grows

Get information to prevent DISK FULL when database grows.  Read more...
By Gonzalo Moles 2015/10/19 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 4,168 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,236 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,661 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,531 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 | 850 reads
   Items 1 to 20 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)