SQLServerCentral: Content tagged maintenance

Script foreign keys

Using this script you can create a list of sql commands for foreign keys manipulation. Read more...

By Boka 2012/01/10 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 4,452 reads

SQL Server 2005 Index Maintenance

Index maintenance procedure using rebuild or reorganized based on fragementation level. Read more...

By Luke Campbell 2011/10/26 | Source: SQLServerCentral.com | Category: maintenance

Rating:

|

Discuss |

Briefcase | 3,253 reads

Next grow for all databases per disk

This script lets you to know how much disk space will be left after the next database grow taking in account the free space left in the database. Read more...

By Gonzalo Moles 2011/10/11 | Source: SQLServerCentral.com | Category: maintenance

Rating:

|

Discuss |

Briefcase | 915 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 2011/09/08 | Source: SQLServerCentral.com | Category: sql server 7

Rating:

|

Discuss |

Briefcase | 4,854 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 SQLSACT 2011/08/30 | Source: SQLServerCentral.com | Category: indexing

Rating:

|

Discuss |

Briefcase | 654 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 2011/04/19 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 5,468 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,302 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 | 4,379 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 | 3,142 reads

Index usage overview

This view reports almost everything you want to know about your indexes Read more...

By Wilfred van Dijk 2010/06/09 | Source: SQLServerCentral.com | Category: indexing

Rating:

|

Discuss |

Briefcase | 3,652 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 2010/05/24 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 4,422 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,848 reads

Index usage overview

This view reports almost everything you want to know about your indexes Read more...

By Wilfred van Dijk 2010/06/09 | Source: SQLServerCentral.com | Category: indexing

Rating:

|

Discuss |

Briefcase | 3,652 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 | 2,072 reads

Catching errors in DBCC CHECKDB

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 2010/05/24 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 4,422 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...

By Jesse Roberge 2009/10/22 | Source: SQLServerCentral.com | Category: lock and connection management

Rating:

|

Discuss |

Briefcase | 5,568 reads