Sql

Partial index

A partial index is a valuable feature supported by various relational databases but is…

[ SQL Performance Killers] — Individual inserts vs. Bulk inserts.

An important part of my daily work…

[ SQL performance Killers ] — STALE STATISTICS

An important part of my daily work is to help…

[ SQL performance Killers ] — VIEWS

An important part of my daily work is to help developers, database…

[ SQL performance Killers ] — Implicit Conversions

An important part of my daily work is to help…

[ SQL performance Killers ] — IN vs EXISTS

An important part of my daily work is to help developers, database administrators…

[ SQL performance Killers ] - Functions to column data

Cause or Consequence?

One of the key factors for a successful application tuning is to find the root cause of the performance issues.

It sounds obvious but it’s common to see a lot of effort and resource being wasted trying to solve what seems to be the cause of the problem but instead…

There are no N-steps to write the best queries in the world.

It’s no news that SQL tuning can be a very complex and time-consuming task. The main problem is that there is no “Rule of Thumb”. For every rule of thumb, there are many cases to prove that that rule of thumb is wrong in as…