I have posted a blog post about Different ways to find DISTINCT values where I have shown six different ways to find DISTINCT values. Here is the analysis of how long each method takes. Create a temporary table named #sales_detailscreate table #sales_de...

SQL Server Integration Services (SSIS) is one of the tools that can be effectively used to transfer data to various destinations. In versions prior to 2005, we had Import/Export wizard which was part of Database Engine and a package would be created bas...

There was a question in the forum on how to Sort mixed value strings “numerically” Consider the following set of datacreate table #test(val varchar(10)) insert into #test select '1002' union all select '29C' union all select '1' union all select '205' u...

Suppose you have Employee_mst table now how to find store procedure uses this Employee_Mst table? ...

Take a look at how SQL Server Import Export Wizard creates an SSIS Package to do the ETL. ...

This article explains what a Data Flow Task is and what the aspects of Data Flow Task worth noting for a beginner....

Unfortunately SSIS does not provide regular expression or an IsNumeric check which is required very often to validate the data. I came across a neat work around. Here it goes: In the derive column set up the following expression for a new column. (...

Often I see lot of SQL deveopers complaining about the error when using datetime values in their queries. The common error that almost everyone would heard about is "Conversion failed when converting date and/or time from character string." But in gener...

Beside XML, JSON is the most common way of data transfer in AJAX applications. We will study this file format in more details in this section....

Recently we have seen the post for database size information and script used for the same too. Hope you liked that post. Sometime we need to have details like database size for growth and disk planning as we viewed in earlier post, same way i am repeati...