tags:

views:

294

answers:

1
+1  Q: 

Performance using T-SQL PIVOT vs SSIS PIVOT Transformation Component.

Hi

I am in process of building Dimension from EDW (source), wherein I need to pivot columns of source to load Dimension.

Currently most of the pivoting stuff am doing is by using T-SQL PIVOT which further get used in my SSIS package to merge with Dim table

This pivoting can also be achieved by SSIS PIVOT Transformation component.

In regards to Performance which approach would be the best?

Thanks

A: 

In theory, SQL Server pivot perf should be faster, or at least the same, but to be sure, requires doing some perf comparison tests.

But even if SSIS currently has the advantage, feel free to use SQL Server, as staying out of SSIS is a good thing.

Scott Weinstein  2010-05-30 21:11:19

related questions

*= in Sybase SQL
sql missing rows when grouped by DAY, MONTH, YEAR
Adapt Replace all strings in all tables to work with text
Can you call a webservice from TSQL code?
How to tell the data types after executing a stored procedure?
C# - SQLClient - Simplest INSERT
SQL Server: Get data for only the past year
Get last item in a table - SQL
Is there a way to make a TSQL variable constant?
Create a database from another database?
SQL Server PIVOT examples?
What are some references, lessons and or best practices for SQL optimization training.
What's a good way to check if two datetimes are on the same calendar day in TSQL?
Trigger without a transaction?
How do I do an Upsert Into Table?
What is the easiest way using T-SQL / MS-SQL to append a string to existing table cells?
How do I avoid using cursors in Sybase (T-SQL)?
Best .NET Solution for Frequently Changed Database
T-Sql date format for seconds since last epoch / formatting for sqlite input
HOWTO - Compare a date string to datetime in SQL Server?
Differences Between MySql and MS SQL
Best method for varchar date validation in Sybase (T-SQL)?
interrogating table lock schemes in T-SQL
Testing for inequality in T-SQL
T-Sql Remove Decimal Point From Money Data Type