Join Network
Categories
Archives
Follow up to: Procedures and Performance
Q: Concerning your article "Procedures and Performance" (article ID 54505 at SystemiNetwork.com ) maybe you could improve the performance of your procedure using the STATIC keyword in the local variable definition? A: Good question. I had the question o ...
Procedures and Performance
I had a performance issue while converting a subroutine to a subprocedure. I searched through my logic looking for reasons, but found nothing wrong. The issue was elsewhere. In this article I show you the pitfall that I discovered and how to avoid it wh ...
Build a New Interface to Legacy Applications with SQL UDTFs
With a good method and a good tool, writing a modern application is easy. But what can you do when you need to work with a piece of "untouchable" legacy code? After all, many companies stick to the old mantra of "if it ain't broke, don't fix it!" For ex ...