Browse by Tags

SQL Server Integration Services - think about Transactions and Checkpointing?
07 April 08 07:21 AM | ssqa.net | with no comments

Transactions and Checkpoints are important factors for data consistency, when it comes for ETL processes that too on SSIS what is your stand? I'm covering this important task for the sake of newbie & junior DBAs, also the similar question was...

Filed under: sql server, best practices, ssis, setup, package, checkpoint, bol, commit, rollback, dts, ssis package, transaction

How to get rowcount efficiently within a SSIS package?
26 March 08 07:51 AM | ssqa.net | with no comments

I would like to call this as how efficiently you can obtain counting rows in SSIS package. Usual thought would come is @@rowcount or COUNT_BIG functions, but this is not that efficient way to obtain the results. SSIS provides the snippet within its components...

Filed under: sql server, performance, ssis, component, package, call, rowcount

Data Warehouse Scalability Features in SQL Server 2008
07 March 08 01:44 PM | ssqa.net | 1 comment(s)

By now you might be aware or have gone through the web resources and conferences about what's new within SQL Server 2008 version, one thing is sure scalability for your database platform. Though there isn't a real-time data warehouse implementation within...

Filed under: sql server, 2008, reporting services, blogs, new, technet, ssis, management studio, data warehousing, ssrs, features, documentation, analysis services, ssas, integration services