| 1. | | Myth: Select * is Bad (use-the-index-luke.com) |
|
87 points by fatalmind on Aug 25, 2013 | past | 67 comments
|
|
| 2. | | What every developer should know about SQL performance (use-the-index-luke.com) |
|
1 point by fatalmind on Aug 16, 2013 | past
|
|
| 3. | | Use The Index, Luke: SQL performance guide now with online examples on SQLFiddle (use-the-index-luke.com) |
|
2 points by fatalmind on Aug 13, 2013 | past
|
|
| 4. | | About SQL Query Hints: Not all hints are born equally (use-the-index-luke.com) |
|
1 point by fatalmind on July 26, 2013 | past
|
|
| 5. | | There are only two hard problems in web design: Internet Explorer and Fonts. (twitter.com/markuswinand) |
|
2 points by fatalmind on July 18, 2013 | past
|
|
| 6. | | Indexes: The neglected performance all-rounder (use-the-index-luke.com) |
|
2 points by fatalmind on July 11, 2013 | past
|
|
| 7. | | Afraid of SSD? (use-the-index-luke.com) |
|
1 point by fatalmind on July 2, 2013 | past | 1 comment
|
|
| 8. | | A URL to toss at your SQL devs (use-the-index-luke.com) |
|
1 point by fatalmind on April 25, 2013 | past
|
|
| 9. | | The two top performance problems caused by ORM tools (use-the-index-luke.com) |
|
5 points by fatalmind on April 23, 2013 | past | 1 comment
|
|
| 10. | | The second power of SQL indexes: Clustering Data (use-the-index-luke.com) |
|
3 points by fatalmind on April 22, 2013 | past
|
|
| 11. | | Response Time, Throughput and Horizontal Scalability (use-the-index-luke.com) |
|
2 points by fatalmind on April 21, 2013 | past
|
|
| 12. | | Database indexing is a development task—it needs the same care as schema design (use-the-index-luke.com) |
|
7 points by fatalmind on April 20, 2013 | past
|
|
| 13. | | FOSDEM Impressions (use-the-index-luke.com) |
|
1 point by fatalmind on Feb 5, 2013 | past
|
|
| 14. | | SQL Indexing and Tuning e-Book (use-the-index-luke.com) |
|
130 points by fatalmind on Dec 16, 2012 | past | 11 comments
|
|
| 15. | | Expert, competent, or greenhorn? Test your SQL performance skills in 3 minutes (use-the-index-luke.com) |
|
1 point by fatalmind on Dec 14, 2012 | past
|
|
| 16. | | Adding hardware won't fix response time problems. (use-the-index-luke.com) |
|
1 point by fatalmind on Oct 3, 2012 | past
|
|
| 17. | | Indexing many columns individually won't give you best database performance (use-the-index-luke.com) |
|
1 point by fatalmind on Sept 24, 2012 | past
|
|
| 18. | | A quiz that teaches you how to avoid the most common SQL performance issues (use-the-index-luke.com) |
|
1 point by fatalmind on Aug 16, 2012 | past
|
|
| 19. | | Get to know your ORM and take control of joins. (use-the-index-luke.com) |
|
40 points by fatalmind on July 18, 2012 | past | 23 comments
|
|
| 20. | | Stop worrying and learn to use the index (use-the-index-luke.com) |
|
2 points by fatalmind on July 4, 2012 | past
|
|
| 21. | | A visual explanation why SQL's LIKE is slow (use-the-index-luke.com) |
|
1 point by fatalmind on June 24, 2012 | past
|
|
| 22. | | Performance impact of sloppy indexing in SQL databases (use-the-index-luke.com) |
|
1 point by fatalmind on June 19, 2012 | past
|
|
| 23. | | Table of Contents: Everything developers need to know about SQL performance (use-the-index-luke.com) |
|
1 point by fatalmind on May 18, 2012 | past
|
|
| 24. | | Not using SQL bind parameters is like recompiling a program every time. (use-the-index-luke.com) |
|
1 point by fatalmind on May 15, 2012 | past
|
|
| 25. | | Database scalability is not only about scale-up, scale-out and hardware... (use-the-index-luke.com) |
|
1 point by fatalmind on April 28, 2012 | past
|
|
| 26. | | NULL in the Oracle Database — Is it special, or strange, or just wrong? (use-the-index-luke.com) |
|
2 points by fatalmind on April 21, 2012 | past | 1 comment
|
|
| 27. | | Reading Database Execution Plans (MySQL, PostgreSQL, Oracle, and SQL Server) (use-the-index-luke.com) |
|
1 point by fatalmind on April 17, 2012 | past | 1 comment
|
|
| 28. | | Several ways to SQL pagination, including performance charts (use-the-index-luke.com) |
|
22 points by fatalmind on March 16, 2012 | past | 5 comments
|
|
| 29. | | SQL Paging queries using SQL "window functions" (use-the-index-luke.com) |
|
2 points by fatalmind on Feb 10, 2012 | past
|
|
| 30. | | SQL pagination in constant time using the "seek method" (use-the-index-luke.com) |
|
4 points by fatalmind on Feb 2, 2012 | past | 1 comment
|
|
|
|
More |
