Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 

Scripts with tag SQL Server 2008 Rss

Search for any content tagged sql server 2008

Add a script

   Items 1 to 20 of 23    Next 20 >>
 

2008 Index Rebuild using DMV

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.  Read more...
By Tommy Bollhofer 2012/08/09 | Source: SQLServerCentral.com | Category: indexing | SQL Scripts Manager Compatible
Rating: |  Discuss |   Briefcase | 1,413 reads

Get Top Queries Taxing SQL Server CPUs

Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.  Read more...
By Prakash Heda 2013/05/25 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,235 reads

Fix SSRS Subscription Owners

Stored procedure to update SSRS Subscription owners to avoid email errors.  Read more...
By Michael Lascuola 2012/03/13 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 799 reads

sp_JobSchedule_rpt for SQL 2005/8

I just took the stored procedure documented here: http://www.sql-server-performance.com/2002/job-report/ ?? ...and made it work on 2005/2008.   Read more...
By Sekhar Mynam 2012/02/23 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,228 reads

create jobs script for 2000 2005 or 2008

will create jobs script for backup or DR purposes to install on another server.  Read more...
By Gene Hunter 2012/01/18 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 1,781 reads

Detach All User Databases

Detach all user databases on a SQL 2008 instance  Read more...
By Chris McGowan 2011/08/24 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 820 reads

Check status of active transactions

Script to check status of active transactions.  Read more...
By Harsha Majety 2011/08/04 | Source: SQLServerCentral.com | Category: status
Rating: |  Discuss |   Briefcase | 1,940 reads

SQL DBAdmin toolbox - Part 1: Restore single database

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.   Read more...
By Infostar 2011/06/10 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,375 reads

Kill all connection to database

Procedure tries to kill all connections to the specified database.  Read more...
By Rafal Skotak 2011/03/01 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 3,694 reads

Backup Compression Ratio

Display's backup compression ration for SQL 2008 (Enterprise or Developer)  Read more...
By Gregory Ferdinandsen 2010/08/31 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 971 reads

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.  Read more...
By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,636 reads

Find weak login passwords in your server

Use this script to search for SQL Server logins who use weak password  Read more...
By Th Tr 2010/01/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,384 reads

Script to Compress Tables and Indexes

This script creates scripts to compress all tables and indexes in a database.   Read more...
By Jeremy Egbert 2010/01/04 | Source: SQLServerCentral.com | Category: compress
Rating: |  Discuss |   Briefcase | 3,082 reads

Generate stored procedure parameter list based on table

Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.   Read more...
By Thomas Cournane 2009/12/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,535 reads

Scripts for Full DB Compression at partition level

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.   Read more...
By Jay Rajgor 2009/11/18 | Source: SQLServerCentral.com | Category: data compression
Rating: |  Discuss |   Briefcase | 947 reads

usp_ShrinkAllLogs

Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method.  Read more...
By Banyardi Schmardi 2009/11/27 | Source: SQLServerCentral.com | Category: truncate table
Rating: |  Discuss |   Briefcase | 894 reads

SQL 2008 : Uncompressed Objects Procedure

A Stored Procedure for your tools database. It lists uncompressed tables and indexes and also generates the SQL to compress them.   Read more...
By Richard Doering 2010/12/22 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 666 reads

Cluster Information

This script will display information about the instance(s) on your cluster. Name of nodes, active node and drive letters of the resources  Read more...
By Rudy Panigas 2009/05/08 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 1,162 reads

SQL 2008 MERGE using Dynamic SQL over a Linked Server

Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.   Read more...
By Tommy Bollhofer 2010/05/31 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,157 reads

Change Ownership of a Maintenance Plan

Change owner of a maintenance plan so the SQL Agent jobs have the correct owner for running.   Read more...
By Phill Carter 2013/05/25 | Source: SQLServerCentral.com | Category: ownership
Rating: |  Discuss |   Briefcase | 2,747 reads
   Items 1 to 20 of 23    Next 20 >>
 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.