SQL Server

When you have to resort to statistics, you know it’s time to redesign the software, or throw it away!

Yesterday the system was running fun. Today it is slow. What changed? How many times has this damn question been asked? The answer is ...Read more

SQL Server to Oracle migration – déjà vu 002

Having migrated many systems from SQL Server to Oracle, I used to want to cry when I encounter this type of construct. [code ...Read more

SQL Server to Oracle migration – déjà vu 001

Every time I undertake a project to migrate a system from SQL Server to Oracle, I am reminded how deficient and cumbersome it ...Read more

ANSI SQL/Foundation

I have believed for some time that the SQL FROM clause is optional, that is optional from the standpoint of ANSI/IEC/ISO standards, not from ...Read more