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

Scripts by Richard Doering

SQLServerCentral.com profile

   Items 1 to 7 of 7   
 

Windows Group Membership Checker

A script to reveal which logins have access to your sql server via windows groups.   Read more...
By Richard Doering 2010/09/01 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,013 reads

Backup all Filegroups

A short script to backup all filegroups, for those who utilise filegroups within a database.  Read more...
By Richard Doering 2011/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,162 reads

Index Fragmentation Status (includes Partitioned Tables/Indexes)

This script reveals the state of your indexes. It breaks down the indexes where they are partitioned, matching the index to it’s partition and filegroup.   Read more...
By Richard Doering 2010/12/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,322 reads

Charpad - Character Padding Function

A generic character padding function. Useful for situations where you need fixed width formatting e.g. email reports.  Read more...
By Richard Doering 2010/12/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,931 reads

Linked Server Connectivity Test

A short procedure for your tools database. Use it to test connectivity to linked servers.  Read more...
By Richard Doering 2010/12/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,272 reads

Column Size Checker

A T-SQL script that reveals how appropriate your choice of column sizes is.  Read more...
By Richard Doering 2010/12/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,278 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 | 690 reads
   Items 1 to 7 of 7