Category Archives: SQL Server 2008

Post your comments, suggestions and queries regarding SQL Server 2008 here…!

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 | 1 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 | 1 Comment

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

Replicate/Migrate data from one database/table to another – Part 3

As we discussed in Part 1/Part 2 about the very simple approaches of migrating the changes from one data table to another, but depending upon the situations, data volume etc., there are a few improvements needed in those approaches. In … Continue reading

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

Replicate/Migrate data from one database/table to another – part 1

This is about a very simple though very useful and frequently used requirement to replicate/merge data from one database/table to another. There can be various scenarios wherein we do get data from multiple sources into one database/table and then we … Continue reading

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

Dynamic Named Sets in SQL Server 2008 Analysis Services (SSAS 2008)

Introduction: SSAS is having a nice & useful feature of defining the calculations (Calculated Members & Named Sets). These calculations can then be used in MDX or by any other client tools etc. These calculations come very handy to allow … Continue reading

Posted in SQL Server 2008, SSAS 2008 | 6 Comments