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 61    Next 20 >>
 

Script foreign keys

Using this script you can create a list of sql commands for foreign keys manipulation.  Read more...
By Boka 0001/01/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 4,073 reads

SQL Server 2005 Index Maintenance

Index maintenance procedure using rebuild or reorganized based on fragementation level.  Read more...
By Luke Campbell 0001/01/01 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |  Briefcase | 3,040 reads

Next grow for all databases per disk

This script lets you to know how much would grow all databases if it would happen at the same time and prevent disk full.   Read more...
By Gonzalo Moles 2011/10/11 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |  Briefcase | 684 reads

Script a Database Role

Script one or all roles in a database. Includes users, obect permissions and column permissions.  Read more...
By Ed Vassie 0001/01/01 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |  Briefcase | 4,434 reads

List all tables without LOB columns

Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml). Useful when rebuilding indexes online.  Read more...
By derekr 43208 2011/08/30 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |  Briefcase | 515 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 0001/01/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 4,956 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 0001/01/01 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |  Briefcase | 4,103 reads

Automatic Statistics Update Slows Down SQL Server 2005

I have a database which has several tables that have very heavy write operations. These table are very large and some are over a hundred gigabytes. I noticed performance of this database is getting slower and after some investigation we suspect that the Auto Update Statistics function is causing a performance degradation.  Read more...
By Additional Articles 2011/02/25 | Source: MSSQLTips.com | Category: maintenance
Rating: (not yet rated)  Rate this |  Briefcase | 3,965 reads

Index defrag script (21005/2008)

This script will allow reindexing (either rebuild or reorg)  Read more...
By Gregory Ferdinandsen 2010/08/25 | Source: SQLServerCentral.com | Category: reindex
Rating: |  Discuss |  Briefcase | 2,915 reads

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 0001/01/01 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |  Briefcase | 3,499 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 0001/01/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 4,251 reads

Retrieve Default SQL Server Backup Folder using PowerShell

In a previous tip on creating a Function to Return Default SQL Server Backup Folder , you've seen how you can create a T-SQL function to query the registry and retrieve the default SQL Server Backup folder. Is there an easier way to do it in Windows PowerShell?   Read more...
By Additional Articles 2010/04/23 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |  Briefcase | 1,585 reads

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 0001/01/01 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |  Briefcase | 3,499 reads

Shrink Database Files in Size Increments

Auto shrink database files in size increment to a desired file size.  Read more...
By Boris Moyse 2010/03/02 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |  Briefcase | 1,868 reads

Catching errors in DBCC CHECKDB

By Jesse Reich 2009/11/04 | Category: maintenance
Rating: (not yet rated) |  Discuss |  Briefcase | 3,262 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 0001/01/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 4,251 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,363 reads

Identify Obsolete Indexes

Drop indexes no longer being used.  Read more...
By RCC-JAXDBA 2009/10/19 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |  Briefcase | 1,862 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 0001/01/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 2,336 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 0001/01/01 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |  Briefcase | 1,768 reads
   Items 1 to 20 of 61    Next 20 >>
 
Tags
administration (24)    
t-sql (21)    
maintenance and management (20)    
sql server 2005 (20)    
indexing (19)    
utility (16)    
performance tuning (10)    
t-sql aids (9)    
automated dba (7)    
storage (7)    
sys.dm_db_partition_stats (7)    
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)    
backup / restore (3)    
space usage (3)    
sql server 7 (3)    
automation (2)    
buffer cache (2)    
fragmentation (2)    
lock and connection management (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)    
archive (1)    
career (1)    
consulting (1)    
database roles (1)    
dbcc checkdb (1)    
defragment (1)    
delete (1)    
development (1)    
disk space (1)    
duplicate indexes (1)    
growth trend (1)    
kill connections (1)    
kill sessions (1)    
log file maintenance (1)    
maintenance plans (1)    
management (1)    
missing indexes (1)    
performance (1)    
performance and tuning (1)    
powershell (1)    
rebuilding indexes (1)    
reindex (1)    
report (1)    
resource planning (1)    
running aggregate (1)    
running totals (1)    
security (1)    
selectivity (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)    
tuning (1)    
xp_cmdshell (1)