SQL Zone is brought to you in partnership with:

Alec is a Content Curator at DZone and lives in Raleigh, North Carolina. He is interested in Java and Android programming, and databases of all types. When he's not writing for the NoSQL and IoT Zones, you might find him playing bass guitar, writing short stories where nothing happens, or making stuff in Java. Alec is a DZone Zone Leader and has posted 579 posts at DZone. You can read more from them at their website. View Full User Profile

The Best of the Week (May 9): SQL Zone

05.18.2014
| 3610 views |
  • submit to reddit

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (May 9 to May 15). Here they are, in order of popularity:

1. Myth: Select * Is Bad

This is one of the most persistent myths the author has seen in the field. It’s been there for decades. If a myth is alive that long, there must be some truth behind it. So, what could be bad about select *? Let’s have a closer look.

2. Results of the SQL Performance Quiz: 60% Fail

In 2011, the author launched “The 3-Minute Test: What do you know about SQL performance.” It consists of five questions that follow a simple pattern: each shows a query/index pair and asks if it demonstrates proper indexing or not. This article analyzes the 28,000 responses to spot patterns and make observations.

3. The Index You’ve Added is Useless. Why?

In this article, the author explores the fact that Oracle doesn't put NULL values in "ordinary" indexes, the problems this can cause, and how to get around them.

4. How to Import CSV Data into PostgreSQL

Many database servers support CSV data transfers, and this post will show one way you can import CSV files to PostgreSQL.

5. GTIDs in MySQL 5.6: New Replication Protocol, New Ways to Break Replication

Reconnecting a slave to a new master in MySQL 5.6 has always been a challenge, but it is so trivial when GTIDs are enabled. However, using GTIDs is not only about replacing good old binlog file/position with unique identifiers; it is also using a new replication protocol. And if you are not aware of it, it can bite.