It’s the free web-edition of SQL Performance Explained, regarding SQL indexing and tuning for DB2, MySQL, Oracle, PostgreSQL, and SQL Server. SQL indexing is the most effective tuning method—yet it is often neglected during development. Use The Index, Luke explains SQL indexing from grounds up and doesn’t stop at ORM tools like Hibernate. Use The Index, Luke is the free […]
Database Note Taker is a free note-taking app made specifically for SQL databases. It makes a database schema and structures a lot easier to capture and document, and definitely simplifies the database documentation and takes the guesswork out of everyday development with databases. How does it work? More specifically, Connect to your database. Refresh with the current structure of your database. […]
When you have the needs to figure out a MS SQL database’s structure, here are 3 SQL statements that would give you a quick start. While they won’t give you a full picture of the whole database they are definitely going to lead you in a right direction with a quick view of what’s in there right now. List the name […]
Scenario 1, one record is completely identical to another Meaning that there is no way of identifying them who is who. Usually, it happens when the table doesn’t have a unique id field due to the poor database design. Because of that, there is no way in SQL to delete one of these duplications without deleting them all first. You […]