Author Archives: Munish Bansal

Circular Reference in Qlikview

In the last article, we talked about a very common issue of synthetic keys in the QilkView data model and discussed its various resolution techniques. In this article, we gonna talk about another common scenario which leads to a bad … Continue reading

Posted in QlikView | Tagged | 1 Comment

Synthetic table\keys in QlikView – and how to avoid it

I know this is a very basic thing in QlikView, and people who do work on Qlikview must have already experienced synthetic keys. But, since this is my first article on QV & this is something I came across with … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

How to prevent SSIS package creating empty flat file at the destination

It’s very common that SSIS package is developed to generate some output as Flat File (.csv, .dat, .txt etc) by using Flat File Destination component. Content of the same can be sourced from either SQL Server database, some other flat … Continue reading

Posted in SQL Server, SQL Server 2008, SSIS | 2 Comments

Autonomous Error/Event Logging into SQL Server

Error logging or custom logging is a very common requirement while working with any database & its operations; irrespective of the database server type i.e. be it Oracle or SQL Server database. And, when we talk about SQL Server, it … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Database Partitioning into SQL Server / Data Archiving using partitioning mechanism (Part 2)

In part1 of Database partitioning we talked about why we need it and how to implement it into SQL Server database. Also, we have seen how to add new range & filegroups to the existing partitions. Now, in this article, … Continue reading

Posted in SQL Server, SQL Server 2008 | Leave a comment

Database Partitioning into SQL Server (Part 1)

While working on large database/tables we come across several issues – may be queries running slow i.e. data performance issues, time to perform certain maintenance operations and replicating/deleting data from these tables. And to deal with these tailbacks, we think … Continue reading

Posted in SQL Server, SQL Server 2008 | 2 Comments

DELETE vs TRUNCATE – SQL Server

Although this is a very simple question that ‘what is the difference between using DELETE vs TRUNCATE statements in SQL Server’, & both are being used very frequently serving more or less the same purposes, but there are various aspects … Continue reading

Posted in SQL Server, SQL Server 2008 | Leave a comment