Louis Davidson becomes a cracker jack developer:
This week, I want to sell you on two ideas. First, that you can make any query faster with:
- Zero hardware changes
- Zero index changes
- Zero structure
- Just a few simple character changes in every one of your queries
This change I will guarantee will make your queries screamingly faster. Never will your customer’s wait on query results again. You will have no blocking, no latch waits, no waiting whatsoever.
He probably should sell this as a training course, along with its administrator equivalent: databases hate date, and you can’t have data problems if you don’t have any data.