About quering solved

Two months ago i write about real quering, trying to solve 3 issues in a single store procedure for SqlServer 2005: Dinamic criteria, dinamic paging and dinamic ordering. The solution i give last time doesnt contemplate using ordering, but i finally got it. I really dont know why no one have published something like this, cause i spend some hours around internet, in fact it makes me think i havent seen something, but from my point of view it works well.

Why i bother spending some time looking for this answer, if some post show the easy solution: generate the sentence dinamically inside the procedure, well... two smasing reasons... security and speed. And if you think, what others reasons do you have to make store procedures?, maybe none. So if you make the sentence dinamically you have to give permissions to the tables... no good, and therefore you lose speed cause SqlServer have compile the sentence each time it excecute... no good again.

Against the curve

Days ago, i begin to be interested in learn more about riding my GS500, i really dont want to become a pilot but i like to learn some techniques to be more safe or to be prepared to the issues of the road. There are two things i learn, i use, and i like to highlight in this post: motor brake and lie down to the curves.

Motor brake, is the dificult way to brake but is really useful in most of cases, it means that when you are going to brake dont use the back brake, instead you down a gear making your engine increase revs wich without accelerating become a brake. But why?, well first you dont use your brakes so it doesnt get heat (simple), and second at the end of brake your engine is in high revs so you have all the power of your bike wich always are in high revs.