1. for the queries you have inside a stored proc, check to see if they use indexes, wat are the query plans etc, set showplan on. set noexec on etc will tell u wat are the steps the optimizer is taking before it runs the query.

2. same as above

3. sp_recompile <table name> is specified after ui run update stats so that pre-compiled queries (views/procs) can make use of the new stats. while update stats actaully updates the stats of table/index etc.

4. create a view with the columns order as needed and then use the view in the bcp out.

5. read documentation.

6. temporary tables (# tables) are used to store temporary data, like work tables which are needed sometimes to do some data manipulation and they may be dropped once the task is done. this is created in the tempdb which is the scratch pad database that can be used by all, and is usually faster than creating a table in the user database. The drawback is taht the tempdb is cleared everytime a server (ASE) is shutdown, so DO NOT keep permanent tables in the tempdb.