SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Maintenance and Management Rss

   Items 1 to 20 of 840    Older >>

Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.  Read more...
Rating: |  Discuss |   Briefcase | 3,677 reads

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,387 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,597 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,252 reads

Monitor database size with dbcc showfilestats

Use DBCC to help monitor the database size. 
Rating: |  Discuss |   Briefcase | 3,672 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,697 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 | 5,505 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 | 19,108 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 | 6,034 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,638 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 | 19,111 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 | 3,173 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 | 5,500 reads

Generate Job Schedule Descriptions

A SELECT statement which includes the alpha description of each job's schedule  Read more...
Rating: |  Discuss |   Briefcase | 4,387 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,657 reads

Troubleshooting Service Broker (SSB)

Troubleshooting Service Broker (SSB) 
By Johan Bijnens 2011/09/05 | Category: maintenance and management
Rating: |  Discuss |   Briefcase | 2,952 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 | 5,210 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,323 reads
   Items 1 to 20 of 840    Older >>
miscellaneous (333)    
t-sql (237)    
backup and restore (87)    
sqlinsider scripts (87)    
indexing (63)    
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)    
agent jobs (1)    
aggregates (1)    
blogs (1)    
columns (1)    
dba (1)    
defragmentation (1)    
directory (1)    
duplicate indexes (1)    
file size (1)    
foreign keys (fk) (1)    
growth trend (1)    
identity property (1)    
indexed views (1)    
job history (1)    
job scheduling (1)    
log file maintenance (1)    
management (1)    
missing indexes (1)    
report (1)    
running aggregate (1)    
running totals (1)    
scheduling (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)