SQLServerCentral - Scripts by Tommy Bollhofer

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 0001/01/01 | Source: SQLServerCentral.com | Category: Maintenance

Rating:

|

Discuss |

Briefcase | 1,024 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 2009/04/30 | Source: SQLServerCentral.com | Category: SQL Server 2008

Rating:

|

Discuss |

Briefcase | 601 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 2008/11/04 | Source: SQLServerCentral.com | Category: SQL Server 2005

Rating:

|

Discuss |

Briefcase | 1,271 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 | 972 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 2007/12/11 | Source: SQLServerCentral.com | Category: SQL Server 2005

Rating:

|

Discuss |

Briefcase | 3,283 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,284 reads