SQL: taking a step back

Joe Celko has written a very interesting and enjoyable article at the Simple Talk site that I recommend to SQL Server database developers anywhere. We all approach our jobs with different mindsets and it’s always a good idea to step back at times and take a breather. Take a look at how your assumptions and habits could be slowing you down. To whet your appetite his 3 headers are: “Errors in complex technology”, “Getting Rid of Procedural Code” and “Getting Rid of Non-Procedural Code”.

Here’s a quote I just love from it:

People prefer static mental models, rather than a dynamic model. This was also the model for traditional programming languages – when you compile a program, you get the same executable code every time. That does not work in SQL; this is why we have query optimizers rather than procedural code in RDBMS.