Well, very first i did thank to all, and ur included in that. But i saw some one is providing me a hint(looks like dreams comes true), so i put...

Thank you all for your valuable replies. I would like to appreciate if some one make a scenario (simplest one mapped to my problem) and provide me solution/steps to be...

Hello,

My quewtion is related to replacing loop, I am very interested on this. coz i really want to improve performance and I can't find a way to replace cursor....

Yes, sure you can do that...

Open the transformation task (the black arrow) properties. On the last tab (Options) there's a "use fast load" checkbox. Try unchecking that.

Well, I have an empty database or few testing records into it. I want to test its performance before i put this on production like so any users may...

I would appreciate if there is any FREE or Microsoft's Tool available to test LOAD, STRESS, Performance on a database? by suppliing given resourses.

I need a tool like Surface...

Hi Raj,

Although in reporting services we are just using its graphs, tabular report and emailing feature, there are some other really cool things we can do, like report linked to...

I have fixed my problem myself.

The problem was how to get next row if exists then calculate DateDiff (current Row's Time - Next row's time) till end of related rows....

sp_help tbl_tracking_mstr

====================

Session_Idvarchar

Login_Idvarchar

Start_DateTimedatetime

End_DateTimedatetime

IP_Addressvarchar

sp_help tbl_tracking_dtl

====================

Tracking_Dtl_Idnumeric

Session_Idvarchar

Page_Idnumeric

DateStampdatetime

based on sessionId per tracking Page_Id visited, i have to calculate dateStamp difference from 1 Tracking Dtl ID to next page ID.

select TrackingDtlid,

Session_Id, Page_Id, DateStamp, "duration-required" from tbl_tracking_dtl where session_id = '10212F68D7D6DBFE'

TrackingDtlid sessionId pageid datetimestamp duration

283808 10212F68D7D6DBFE 6 2006-02-07 10:28:05.680 21 sec

283812 10212F68D7D6DBFE 8 2006-02-07 10:28:26.523 6 sec

283815 10212F68D7D6DBFE...

sessionIdpageiddatetimestampduration

10212F68D7D6DBFE62006-02-07 10:28:05.68021 sec

10212F68D7D6DBFE82006-02-07 10:28:26.5236 sec

10212F68D7D6DBFE142006-02-07 10:28:32.54022 sec

10212F68D7D6DBFE62006-02-07 10:28:54.790 3619 sec

Thanks for your all replies and suggestions (may be I'm missing someone's comments).

I still prefere dynamic SQL in my case because I tried following, but as you put all cases...

You mean each time (1 or many) user(s) want data based on their requirement, my proc. first create temp tables, create indexes and then push billions of records into it, and then I use...

I don't mind because these were my own comments. Temp tables with joining also sucks. Using temp tables the i can't produce indexing to joing them with other tables. Need...

For the time, after tunning database tables using proper indexing, if there are lots of WHERE and they are dynamic (depends on user's selection) I use dynamic query to solve...