Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abc123
Starting Member
47 Posts |
 Posted - 2008-04-23 : 10:08:36
|
| Hi, Plz give me answer for following questiions1. Which step we will follow to imporve the performance of any stored procedure?(which component should we check?)2. Which step we will follow to imporve the performance of any query?3. Difference between sp_recomplie and update_statics4. have one table with A1 B1 C1 column and i want to do bcp in from a excel file. but excel ile the column sequence as C1 B1 A1 .how i can bcp in? |
|
|
abc123
Starting Member
47 Posts |
Posted - 2008-04-23 : 10:11:20
|
| 5. How error handling is done in stored procedure? |
 |
|
|
abc123
Starting Member
47 Posts |
Posted - 2008-04-23 : 10:13:13
|
| 6. why we use temporary table and drawbacks of tepoparary table? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-23 : 22:41:45
|
| 1. check execution plan.2. same as above, ensure table has useful index.3. first rebuilds query plan while second updates table or view stats.4. bcp to staging table then move to target table with t-sql.5. use raiserror.6. not required, don't use it if don't want.Basiclly, you can find answers in books online easily. |
|
|
|
|
|
|
Some question