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

Scripts by Gregory Ferdinandsen

SQLServerCentral.com profile

   Items 1 to 11 of 11   
 

Script to determine if two instances are on the same node

Determines if two instances of a Active/Active cluster are running on the same node.  Read more...
By Gregory Ferdinandsen 2013/11/13 | Source: SQLServerCentral.com | Category: wmi
Rating: |  Discuss |   Briefcase | 754 reads

Long Running Jobs Monitor

Script to be executed every 60 minutes as a job to determine long running jobs.  Read more...
By Gregory Ferdinandsen 2013/07/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,279 reads

Compress all Objects

A short compression script that will compress all tables or indexes.  Read more...
By Gregory Ferdinandsen 2013/03/01 | Source: SQLServerCentral.com | Category: compression
Rating: (not yet rated) |  Discuss |   Briefcase | 678 reads

SQL Server Index Defragmentation (Updated)

Defrags all indexes in select databases in 2005, 2008, and 2012.  Read more...
By Gregory Ferdinandsen 2014/02/07 | Source: SQLServerCentral.com | Category: admin
Rating: |  Discuss |   Briefcase | 3,199 reads

Compression of all Objects

This script will compress all objects in the database.  Read more...
By Gregory Ferdinandsen 2012/01/26 | Source: SQLServerCentral.com | Category: compression
Rating: (not yet rated) |  Discuss |   Briefcase | 917 reads

Index Defragmentation (2005, 2008, 2012)

Complete script for index defragmentation and updating stats  Read more...
By Gregory Ferdinandsen 2012/01/02 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 2,602 reads

Index Defragmentation and update stats

A thorough SP for rebuilding indexes.  Read more...
By Gregory Ferdinandsen 2011/03/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,235 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 | 1,036 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,236 reads

SQL Server Port Number Script

This is best run through SSMS 2008 against multiple server. When done so, it will display the port number that SQL is listening on.   Read more...
By Gregory Ferdinandsen 2010/05/04 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,305 reads

SQL Server Access Restriction

Restrict Access to SQL by HostName, IP, Application Name, etc...  Read more...
By Gregory Ferdinandsen 2011/07/21 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,946 reads
   Items 1 to 11 of 11