Thanks for the comment. This is just was my point. There are many different ways to do a job and architect. And I was trying to show it. But it...

Let it be this way. Next time I will use your loop control when I can't awoid a big looping structure. Good solution. I am fine with all solutions as...

I am not defencive, but trying to be realistic. If I need over 200 -500 loops then I need to look an alternative to the loop solution and in most...

Possible that optimizer shows that the break is more effective but it is like 10 or 10.01 miles/gal. Is it different? For testing purpose  on factory - yes. In real...

Thanks for the warm words. I do like good solutions and your's is good for the discussion. I do follow your's advise while I am doing quick and dirty tests....

I do understand your point. But as an example I get criteria (not the best one) just to illustrate the point.

If you look my first performance article http://qa.sqlservercentral.com/columnists/lPeysakhovich/overviewofperformance.asp)

you...

Yes, I can do it. Rename indexes, tables, databases, and so on.

But the main point of the article is to show that a simple change may have a big effect. And...

You right if it is the simple table in air. In our case each table has the corresponding names for the PK and indexes. For example, table t_customer will have PK...

Very nice decision. But in my case this is just a quick example. 

This article I placed as a general guideline for the developers because I am tired with obvious performance...

Good solution as well. And achieve the same point.

Second comment. I am writing this article mainly for the application developers and/or report writers. Most of them have no idea...

Cool way. And you got a good idea for the implementation.

There are many ways and many people develop similar processes. I did outlined some of aspects. That's it. sp_who proc is working fine. Who need sp_who2? But it is exists...

Then in your mind, object-relational and object oriented database database design is trash as well.  Lobachevsky's and Newton's teories are different. One working in space and another on the Earth. In...

At the end, the mind should not be locked. And if in specific cases something is valuable, all options should be opened. And I am opened to all ideas...