900 column table must be having a lot of indexes and a complex primary key. What will happen to Update and Delete performance on such tables?

Whatever you are declaring inside your begin try - end try block, does not have any value assigned before insert statement. This is resulting in NULL insertion, thus you are...

This is generated output. Actual script is like

case when

...

Thanks Gail for a nice article.

nice one, but unnecessary exercise as both will have same plans.

15K

Yes we...

Thanks to OP for these valuable "Best Practices" that reminded me of my x-manager who was MBA and "nephew of our CEO". :angry:

ha ha ..... I missed it.

Thanks for review.

Yes you are right, these ORs are main issue. Earlier we had few more ORs, and by removing them I managed to get some 40-45% performance gain (I...

Thanks Chris.

Yes, I had already tried creating # table as you advised. This was showing lot of improvement in i/o stats as main part was executing only 1 time instead...

like it 🙂

Dear All,

Thanks for your kind support. It was really not easy to write a script specially when requirement is not clear. I made a few changes in suggested queries...

But you are not inserting anything in #C and @sql is also not declared.

Some of us could still help you if you had posted your question properly.