We have arranged daily rebuild index jobs on selected tables. I was comparing index fragmentation at various times and strangely found that for one table after data deletion, the index...

Unfortunately that brings me to the same point where I started. In a complex stored procedure, what should be the thumb rule for implementing temporary data [records upto 800].

Gail, we have few tables who have rowcount at around 1000000. These tables have inserts and updates every day for approx four hours. Thereafter delete operation occurs as well. Will...

Off lately we are getting our sproc stuck at every day at same time. We have to update the statistics and then the process starts smoothly. We have pin point...

Gail, How are these _WA_ stats created and on what criteria ? Are these good for performance ?

Please let me know if you have some useful document link on...

Don't need to kill anyone guys....

We are already short of SQL experts.....

Thanks Gail. Nice idea. I'll check that out with execution plan and surely post my findings to this post.

Ninja, though i liked your idea, but still will test the same...

Thanks for the quick reply. Regarding your first point, does it mean that following the first approach is better one ?

On Second Point, I want to clear is whether the...

Thanks SQL Guru for the CONVERT IMPLICIT hint. Rest I'll check on how we can cut down the time. Though this forum I found is of great knowledge fest. It's...

Though it's for big recordset but columns are few (6-8). So i think somehow it should be more efficient. But how, donno. Please let me know if anything can be...

Hello DBA Gurus, Is there something for me ? I've attached the execution plan for the insert as well.

Can anyone please help me out on this ?

Kindly find the execution plan of the INSERT part of the sproc. It's taking 75% part of query [Sproc takes around 40 seconds to complete]. I've updated the statistics on...

Hello SQLGuru, My whole setup was destroyed because of purging. I'll recreate the scenario, check for execution plan and let you know.

Totally Agreed. To take advantage of index you must use "where col1 = function(@var1)".