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

Content with tag Maintenance and Management Rss

   Items 1 to 20 of 839    Older >>
 

Get all user def table info

Get space for all user defined table information like size and row counts.  Read more...
By Mohit Nayyar 2013/12/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,324 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,567 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,194 reads

Monitor database size with dbcc showfilestats

Use DBCC to help monitor the database size.  Read more...
Rating: |  Discuss |   Briefcase | 3,472 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,593 reads

Display Job Schedule Description (SQL Server 2005)

The idea was taken from this script: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/ Which did not work in SQL 2005 due to table changes on MSDB  Read more...
By Cowboy DBA 2013/05/08 | Source: SQLServerCentral.com | Category: maintenance and management
Rating: |  Discuss |   Briefcase | 4,655 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,564 reads

Generate Drop / Create Script for views, stored Procedures

This Script generates drop and create scripts for views or stored procedures.  Read more...
Rating: |  Discuss |   Briefcase | 5,750 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,458 reads

Indexes, Indexes, Indexes

This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.  Read more...
By Ron Johnson 2012/07/04 (first published: 2011/07/05) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 18,853 reads

RYO Maintenance Plan – Database Backups

Remember kids... Anyone who knows me knows that I’m a big proponent of automating routine tasks. If I have to do...  Read more...
By 2012/01/26 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,991 reads

Reduce heap table fragmentation

A table that does not have a clustered index is referred to as a Heap. While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a heap table.  Read more...
By James Serra 2011/12/13 | Source: SQLServerCentral.com | Category: defragmentation
Rating: (not yet rated)  Rate this |   Briefcase | 4,722 reads

Generate Job Schedule Descriptions

A SELECT statement which includes the alpha description of each job's schedule  Read more...
Rating: |  Discuss |   Briefcase | 4,211 reads

Verify Last successful CHECKDB on all databases

Creates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance. Does not work on SQL 2000.  Read more...
By Kyle Neier 2011/09/28 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,523 reads

Troubleshooting Service Broker (SSB)

Troubleshooting Service Broker (SSB)  Read more...
By Johan Bijnens 2011/09/05 | Category: maintenance and management
Rating: |  Discuss |   Briefcase | 2,618 reads

SQL Server Index Maintenance Performance Tuning for Large Tables

If you think about it carefully, you’ll realise, that index maintenance is necessary and that it makes sense, and that SQL Server is not doing this task automatically according to the book.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 4,305 reads

Reindex - Reorganize or Rebuild

In the first time you execute this procedure, might take a long time, but not in the next time. Later you can execute this procedure daily.   Read more...
By Benes Guislandi 2011/08/10 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,275 reads

Indexes, Indexes, Indexes

This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.  Read more...
By Ron Johnson 2012/07/04 (first published: 2011/07/05) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 18,853 reads
   Items 1 to 20 of 839    Older >>
 
Tags
miscellaneous (333)    
t-sql (237)    
sqlinsider scripts (87)    
backup / restore (86)    
indexing (62)    
lock and connection management (36)    
administration (29)    
data warehousing (29)    
sql server 2005 (26)    
utility (23)    
maintenance (20)    
replication (16)    
mail (15)    
performance tuning (10)    
search (8)    
automated dba (7)    
storage (7)    
sys.dm_db_partition_stats (7)    
tables (6)    
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)    
troubleshooting (3)    
buffer cache (2)    
stored procedures (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)    
advanced querying (1)    
aggregates (1)    
backup / recovery (1)    
blogs (1)    
columns (1)    
dba (1)    
defragmentation (1)    
directory (1)    
duplicate indexes (1)    
file size (1)    
foreign keys (fk) (1)    
generate job schedules (1)    
growth trend (1)    
identity property (1)    
indexed views (1)    
job history (1)    
job schedule (1)    
jobs (1)    
log file maintenance (1)    
management (1)    
missing indexes (1)    
report (1)    
running aggregate (1)    
running totals (1)    
selectivity (1)    
sharepoint (1)    
sql server 2008 (1)    
sql server express (1)    
sqlclr (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)    
xp_cmdshell (1)