SQLServerCentral - Scripts by Tommy Bollhofer

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,419 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,894 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,168 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,303 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,134 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,297 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,609 reads