I like the benefit you have shown of the include clause but it’s not very clear how the pages were accessed at the file level and how there are lesser...

Considering you have Rebuild your index; Just a suggestion

•Try creating an index in the following order (region_code ,Call_Datetime, Menu_Name)

•I really don’t like ordering data on the DB; Can you...

There is no coping of data with the switch statement, the “switch” only changes the pointers. But if you have a merge or split involved you are definite to have...

Thanks a lot. This is what i was looking for

Thanks , but I didn't find any thing that helped me

Sorry for not replying earlier , this did the trick:D

Hi Jack

Would you be kind enough to provide the required code to check the file properties in the script task without using the component you recommended.

I wouldn’t totally agree with you on this. My first thoughts were its good to have a derive table “it definitely helps to identify the records which are in OrderHeader...

Hai has any body been able to track the error description if a backup failed(Assuming a the back was a part of a nightly job where all the DB s...

Hi

            Its funny how the same query does not have similar execution plans in 2000 and 2005.  But at the same time I...