Hello long time.. but I were not able to change that cursor into set based query but when I convert the participating table from main one to temp table with selected field and required indexes than it become 98% faster....

I m not able to upload the example may be because of size. but there is two nested cursor where at second level I have manipulation the intermediate values with update statement....

How to optimize the operation under cursor . I use "static" but still it is consuming much time.
...

thanks for your reply chintak. your reply helping me alot. still I m searching for more info about it. I will back very soon....

How can we free memory of Tempdb without restart the server and what are the merits and demerits of that.
...

I agreed with previous answers. here is new one.[Only for permanent tables] IF OBJECT_ID('Test') IS NOT NULL DROP TABLE Test Create table Test(QuestionNo SmallInt, Question Varchar(1000), Option1 Varchar(...

Thank you for your replies. I will look for those option .. thanks again......

Thank you for your replies. I will look for those option .. thanks again......

I m facing performance problem to execute a SP which is having number of sp's in it sequentially. can I use DBCC FREEPROCCACHE DBCC DROPCLEANBUFFERS command in between SP's to free some space and increase the performance.?...

I m facing performance problem to execute a SP which is having number of sp's in it sequentially. can I use DBCC FREEPROCCACHE DBCC DROPCLEANBUFFERS command in between SP's to free some space and increase the performance.? ...