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 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

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...

By Jesse Roberge 0001/01/01 | Source: SQLServerCentral.com | Category: lock and connection management

Rating:

|

Discuss |

Briefcase | 5,363 reads