Hi,
Plz give me answer for following questiions

1. 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_statics

4. 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? (BCP command)

5. How error handling is done in stored procedure?

6. why we use temporary table and drawbacks of tepoparary table?

7. What is Index covering?