Use The Index, Luke: SQL performance guide now with online examples on SQLFiddleuse-the-index-luke.com·2 pts·fatalmind·0
There are only two hard problems in web design: Internet Explorer and Fonts.twitter.com·2 pts·fatalmind·0
Database indexing is a development task—it needs the same care as schema designuse-the-index-luke.com·7 pts·fatalmind·0
Expert, competent, or greenhorn? Test your SQL performance skills in 3 minutesuse-the-index-luke.com·1 pts·fatalmind·0
Indexing many columns individually won't give you best database performanceuse-the-index-luke.com·1 pts·fatalmind·0
A quiz that teaches you how to avoid the most common SQL performance issuesuse-the-index-luke.com·1 pts·fatalmind·0
Table of Contents: Everything developers need to know about SQL performanceuse-the-index-luke.com·1 pts·fatalmind·0
Not using SQL bind parameters is like recompiling a program every time.use-the-index-luke.com·1 pts·fatalmind·0
Database scalability is not only about scale-up, scale-out and hardware...use-the-index-luke.com·1 pts·fatalmind·0
NULL in the Oracle Database — Is it special, or strange, or just wrong?use-the-index-luke.com·2 pts·fatalmind·1
Reading Database Execution Plans (MySQL, PostgreSQL, Oracle, and SQL Server)use-the-index-luke.com·1 pts·fatalmind·1
Several ways to SQL pagination, including performance chartsuse-the-index-luke.com·22 pts·fatalmind·5