• Our Office
  • 12 Alpine Close Lakefield Benoni 1501

Back to Basics: SQL Indexes

SQL Server Index Basics Given the fundamental importance of indexes in databases, it always comes as a surprise how often the proper design of indexes is neglected. It often turns out that the programmer understands detail, but not the broad picture of what indexes do. Bob Sheldon comes to the [...]

Read More

Back to Basics: SQL Joins

I recently had to explain to some people the difference between the different kinds of SQL joins. Now I have been using SQL for well over 15 years and feel myself quite the expert, however this stumped me like a number 10 batsmen facing an Alan Donald yorker. The problem [...]

Read More