SQLServerCentral: Content tagged Maintenance and Management

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 | 3,726 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 | 17,605 reads

Generate Drop / Create Script for views, stored Procedures

This Script generates drop and create scripts for views or stored procedures. Read more...

By Kenneth Nielsen 2013/01/01 | Source: SQLServerCentral.com | Category: maintenance and management

Rating:

|

Discuss |

Briefcase | 5,425 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,201 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,491 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,459 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 | 3,233 reads

Generate Job Schedule Descriptions

A SELECT statement which includes the alpha description of each job's schedule Read more...

By Richard Sutherland 2011/11/25 | Source: SQLServerCentral.com | Category: maintenance and management

Rating:

|

Discuss |

Briefcase | 3,970 reads

Extract More Than 1000 Active Directory Accounts

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,345 reads

Locate primary key - foreign key relations

Troubleshooting Service Broker (SSB)

Troubleshooting Service Broker (SSB) Read more...

By Johan Bijnens 2011/09/05 | Category: maintenance and management

Rating:

|

Discuss |

Briefcase | 2,318 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...

By Additional Articles 2011/08/18 | Source: SQL Server Performance | Category: maintenance and management

Rating: (not yet rated) Rate this |

Briefcase | 3,994 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,184 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,491 reads

Table row count using 3 different ways

Three different ways that you can get the count of the rows in a table. Read more...

By Mohit Nayyar 2011/06/16 | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 6,354 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 2011/06/06 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 6,739 reads

Database Management for SharePoint 2010

With each revision, SharePoint becomes more a SQL Server Database application, with everything that implies for planning and deployment. There are advantages to this: SharePoint can make use of mirroring, data-compression and remote BLOB storage. It can employ advanced tools such as data file compression, and object-level restore. DBAs can employ familiar techniques to speed SharePoint applications. Bert explains the way that SharePoint and SQL Server interact. Read more...

By Additional Articles 2011/05/18 | Source: SimpleTalk | Category: sharepoint

Rating:

Rate this |

Briefcase | 2,671 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 2011/04/18 | Source: SQLServerCentral.com | Category: sql server 2005

Rating:

|

Discuss |

Briefcase | 4,301 reads