SQLServerCentral.com Scripts tagged SQL Server 2008

2008 Index Rebuild using DMV

Thu, 09 Aug 2012 06:00:00 UT

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.

Get Top Queries Taxing SQL Server CPUs

Sun, 11 Mar 2012 02:19:09 UT

Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.

Fix SSRS Subscription Owners

Tue, 13 Mar 2012 06:00:00 UT

Stored procedure to update SSRS Subscription owners to avoid email errors.

sp_JobSchedule_rpt for SQL 2005/8

Thu, 23 Feb 2012 07:00:00 UT

I just took the stored procedure documented here: http://www.sql-server-performance.com/2002/job-report/ ?? ...and made it work on 2005/2008.

create jobs script for 2000 2005 or 2008

Wed, 18 Jan 2012 07:00:00 UT

will create jobs script for backup or DR purposes to install on another server.

Detach All User Databases

Wed, 24 Aug 2011 06:00:00 UT

Detach all user databases on a SQL 2008 instance

Check status of active transactions

Thu, 04 Aug 2011 06:00:00 UT

Script to check status of active transactions.

SQL DBAdmin toolbox - Part 1: Restore single database

Fri, 10 Jun 2011 06:00:00 UT

A stored procedure for restoring a database up to the latest log backup from a file folder. Compatible with the backups made by standard SQL maintenance plan.

Kill all connection to database

Tue, 01 Mar 2011 07:00:00 UT

Procedure tries to kill all connections to the specified database.

Backup Compression Ratio

Tue, 31 Aug 2010 06:00:00 UT

Display's backup compression ration for SQL 2008 (Enterprise or Developer)

EXECute SQL Commands over entire sets of parameters!

Tue, 16 Mar 2010 06:00:00 UT

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.

Find weak login passwords in your server

Tue, 05 Jan 2010 07:00:00 UT

Use this script to search for SQL Server logins who use weak password

Script to Compress Tables and Indexes

Mon, 04 Jan 2010 07:00:00 UT

This script creates scripts to compress all tables and indexes in a database.

Generate stored procedure parameter list based on table

Fri, 04 Dec 2009 07:00:00 UT

Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.

Scripts for Full DB Compression at partition level

Wed, 18 Nov 2009 07:00:00 UT

Data compression is a key feature with SQL 2008. This script, can compress all DB objects (partition/non-partitioned) according to Partition Range you specifiy.

usp_ShrinkAllLogs

Fri, 27 Nov 2009 07:00:00 UT

Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method.

SQL 2008 : Uncompressed Objects Procedure

Wed, 22 Dec 2010 07:00:00 UT

A Stored Procedure for your tools database. It lists uncompressed tables and indexes and also generates the SQL to compress them.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Cluster Information

Fri, 08 May 2009 06:00:00 UT

This script will display information about the instance(s) on your cluster. Name of nodes, active node and drive letters of the resources

SQL 2008 MERGE using Dynamic SQL over a Linked Server

Mon, 31 May 2010 06:00:00 UT

Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.

Change Ownership of a Maintenance Plan

Fri, 12 Dec 2008 10:14:16 UT

Change owner of a maintenance plan so the SQL Agent jobs have the correct owner for running.

Invalid SKU Error when Adding a Node to a SQL 2008 Cluster

Sun, 07 Sep 2008 15:28:25 UT

When trying to add a node to an existing SQL Server 2008 cluster you get an Invalid SKU Error

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

SQL Server 2008 index fragmentation

Thu, 15 May 2008 06:00:00 UT

Script to see how fragmented the indexes are.

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Wed, 13 Mar 2013 06:00:00 UT

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.