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

Content with tag Maintenance Rss

   Items 1 to 20 of 96    Older >>
 

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,000 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 | 5,952 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,774 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,955 reads

Check Backups

Daily maintenance script to check on backups  Read more...
By Greg Ryan 2014/07/04 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 2,525 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 | 908 reads

Heaps rebuild

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

Prevent DISK FULL when database grows

Get information to prevent DISK FULL when database grows.  Read more...
By Gonzalo Moles 2013/09/13 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 2,569 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,226 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,636 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,458 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 | 843 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,125 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 | 810 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 | 1,944 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 | 667 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,513 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,250 reads
   Items 1 to 20 of 96    Older >>
 
Tags
administration (26)    
indexing (23)    
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 / 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)    
powershell (3)    
space usage (3)    
sql server 7 (3)    
automation (2)    
backups (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 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)    
press release (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)    
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)