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

Scripts by Tommy Bollhofer

SQLServerCentral.com profile

   Items 1 to 7 of 7   
 

2008 Index Rebuild using DMV

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.  Read more...
Rating: |  Discuss |   Briefcase | 1,565 reads

Shrink Log File to Target Percentage

Performs a checkpoint or a transaction log backup followed by a DBCC SHRINKFILE on the transaction log to the target percentage specified relative to the total data file(s) size.  Read more...
By Tommy Bollhofer 2009/09/23 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 1,969 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,349 reads

SSIS Synchronize Remote FTP Directory

Get a distinct list of file names from a table into an ArrayList and compare against a remote FTP server. Retrieve only the files that have not already been processed into the database.  Read more...
By Tommy Bollhofer 2013/05/17 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 2,407 reads

2005 Blocking Locks RDL for Management Studio

RDL for use in MSSSQL 2005's Management Studio (custom reports).   Read more...
By Tommy Bollhofer 2008/03/28 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,151 reads

2005 Online Index Rebuild using DMV

Identifies indexes with average logical fragmentation >= 30% using the DM available in MSSQL 2005. Please refer to script for more information.  Read more...
By Tommy Bollhofer 2012/07/31 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 4,326 reads

2005 Database Monitor RDL for Management Studio

RDL for use in MSSSQL 2005's Management Studio (custom reports).   Read more...
By Tommy Bollhofer 2007/12/04 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 2,629 reads
   Items 1 to 7 of 7