0 - 4 of 4 tags for ms sql server

We have a a number of processes where in we transfer the data from SQL server to TD. We extract he data as files & then dump it using Fastload. Just wanted to know is there any other process we can experiment to make this load any more faster ? The record number is a bit high so takes around significant time.
Hope I made myself clear.

I have a basic knowledge about Microsoft SQL Server Profiler but I want to know that can I monitor a production environment to see which stored procedures are affecting performance by executing too slowly?
 

How can I detach and attach the SQL database by SP. please help because I want to change the location of my database.

Hi have a TPT job that connects to SQL Server 2005 to select rows from and load Teradata target table via UPDATE.  I'm using the MIcrosoft SQL Server ODBC driver to connect (Yes, I know its not certified).