Federico Iori (2/5/2013)

How could I launch from T-SQL a SSIS package ? The only way I know is using xp_cmdshell.. purpose of the article was a T-SQL stored procedure able...

I won't argue with you on the complexities of "doing SSIS right", but from extensive experience using both sets of technologies it is infinitely more scalable and robust in the...

I'm not sure if you're looking for ammunition to get this change enacted in your environment (been there) or looking for alternatives but I'll quickly speak to both.

The problem many...

You mention design and I think that's where you need to start when working with a VLDB. I administer multiple TB+ databases in my environment and the key is...

It looks like your stored procedure contains an input parameter defined as varchar(25), which needs to encapsulate the entire comma-separated string passed in from your multi-select SSRS report. Based...

Thanks for reading.

I agree that not having access to the data collector GUI/stored procedures on SQL 2000/2005 instances makes it difficult to use the MDW as an enterprise-wide trending/profiling solution....

As Rich says there are faster/less resource intensive ways to get the data in question . The following script can be run at the database level to get row/page...