SQLServerCentral - Scripts by Gregory Ferdinandsen

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

Briefcase | 737 reads

Complete script for index defragmentation and updating stats Read more...

By Gregory Ferdinandsen 2012/01/02 | Source: SQLServerCentral.com | Category: fragmentation

Rating:

|

Briefcase | 1,898 reads

A thorough SP for rebuilding indexes. Read more...

By Gregory Ferdinandsen 2011/03/15 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Briefcase | 2,788 reads

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:

|

Briefcase | 877 reads

This script will allow reindexing (either rebuild or reorg) Read more...

By Gregory Ferdinandsen 2010/08/25 | Source: SQLServerCentral.com | Category: reindex

Rating:

|

Briefcase | 3,003 reads

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:

|

Briefcase | 2,108 reads

Restrict Access to SQL by HostName, IP, Application Name, etc... Read more...

By Gregory Ferdinandsen 0001/01/01 | Source: SQLServerCentral.com | Category: security

Rating:

|

Briefcase | 2,670 reads