SQL Lion

6^th June 2009

Delete Redundant Rows from Database

User: Anonymous

Problem Statement

We have a large set of databases, each containing more than 100 tables. The problem is some of the tables have redundant rows. Removing those redundant rows manually is bit difficult. Is there any way to detect only those tables that contain redundant rows and delete them?

Solution

Detecting redundancy is not a big problem as compare to deletion operation of the same. Please refer the article named [Delete Duplicate Records] to get more clarity on removing duplicate records.

And to ease the process of deleting the redundancy in any database, SQL Lion team has come up with a tool named “Duplicate Remover” that will search and delete duplicate data (rows) in your SQL Server database. All redundant entries are eliminated except the real one.

Download Duplicate Remover for free from here.

24^th May 2009

Batch SSIS logging

User: Anonymous

Problem Statement

We have a bunch of SSIS packages with no logging implemented. But now there is a requirement to set some logs in those packages in order to audit it better.  But setting logging to each package manually is cumbersome and time taking. Is there any way to implement same set of logging to all these packages at a time?

Solution

SQL Server Integration service comes with a very great and finest set of logging modules. You can set these logs as per your need. To set batch logging in the SSIS packages, SQL team has come up with a solution named “Expert Logger”. It supports both 2005 and 2008 Integration services. Download it, run it and select the logs as per your need and Expert Logger will set the logs in all the packages at once. It’s a batch processing system. All your packages should be in a folder and so that it can be processed to set SSIS logging to each package one by one.

Remember to take BACKUP of the packages before processing it by Expert Logger.

Download Expert Logger for free here.