There's no way to teach SSIS within a post on a newsgroup. However, I can point you to a few articles available on the site that should get you started.

http://www.sqlservercentral.com/articles/introductiontodtsinsqlserver2005/1486/

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/thenewetlparadigm/1719/

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/upgradingsqlserver2000dtspackagestossis/2201/

Here's...

One other thing you might check is running Profiler and getting statement complete events. This puts a significant load on the server, but you'd see the actual cost of each...

Text data is just strings as far as SQL Server is concerned and UPPER is not any kind of data limit, but rather a format. You can probably use an...

Use this code to create the linked server (the example is for connecting to Oracle):

EXEC master.dbo.sp_addlinkedserver @server = N'ServerName', @srvproduct=N'MSDAORA', @provider=N'MSDAORA', @datasrc=N'connectstring'

Then your TSQL just needs to include the server...

You should look at Integration Services. This is the primary Extract Transform & Load (ETL) tool for SQL Server. It can open a large variety of data types and move...

Excellent. Now you just need to look into those two clustered index scans to see if you can improve the performance even more. Look at your table and the predicates...

Without structure & data, it'll be really hard to say.

Do you have the execution plan? Can you post the estimated plan for the full query that takes too long to...

Not for me. In general, the suggestions so far won't hurt performance on a 2gb database and they will help performance on larger databases. It's easy and free, so why...

Bad news, that must have been someone's private example. I don't have anything like that in the slides that they provided to us. I wish I did. The slides provided...

And to really muck up the environment some more, add a filegroup for storing text or (MAX) columns too.

One other note, we do this regularly because, as Steve state, sharing the load across multiple access points is a simple win. However, you now need to be careful about...

Yeah, that's true. Sorry, I should have clarified. My issue is to prevent the INSERT...SELECT...INSERT chain and the OUTPUT clause bypasses that horror show quite well. I do tend to...

Here's a quick example. I'm only using a single row, but the same methodology will work with multiple rows:

CREATE TABLE Master1

(

Master1Id...

Jack Corbett (3/28/2008)

---

Count me on board the biometric side of the debate. I still think my credit card data is safer in a database than when I hand it...

Yeah, Microsoft Connect. You can submit requests for features or changes, etc. Then, you can let others know about the change you've submitted and they can go & vote for...