Jim Tilson

Follow Jim Tilson via

11 November 2011
11 November 2011

Which of these things is not like the other?

0
0
Have you ever played the game where you try to identify the differences between two side-by-side seemingly-identical pictures? Sometimes answering the question “why does my query perform well in development, but it drags in test and production” is the same sort of game: you must identify where your environments differ, either obviously and subtly, then weigh those differences to determin… Read more
0
0
14 September 2011
14 September 2011

Writing Better Dynamic SQL

0
0
Dynamic SQL is a powerful tool. In its proper place it can achieve quite a bit of work in a relatively small amount of code. Used improperly, however, it can cause all sorts of code maintenance headaches. Consider the following procedure. It uses the HR schema and sample data that comes with an installation of the Oracle database: CREATE OR… Read more
0
0