SQL
-
Software Development
Fixed-Point and Floating-Point: Two Things That Don’t Go Well Together
One of the more challenging aspects of software development can be dealing with floating-point numbers. David Goldberg‘s 1991 Computing Surveys…
Read More » -
Software Development
Apache Drill SQL Queries on Parquet Data
In this week’s Whiteboard Walkthrough Parth Chandra, Chair of PMC for Apache Drill project and member of MapR engineering team,…
Read More » -
Software Development
How to remove duplicate rows from a table in SQL
There are a couple of ways to remove duplicate rows from a table in SQL e.g. you can use a…
Read More » -
Software Development
Using Apache Spark SQL to Explore S&P 500, and Oil Stock Prices
This post will use Apache Spark SQL and DataFrames to query, compare and explore S&P 500, Exxon and Anadarko Petroleum…
Read More » -
Software Development
SQL Query on Mixed Schema Data Using Apache Drill
You may have heard this statement before: Apache Drill does schema discovery on-the-fly. What does that mean, and why should…
Read More » -
Software Development
SQL for Application Developers
“SQL? Isn’t that just something my ORM tools use?” Often application developers can and should remain at least one level…
Read More » -
Software Development
Correlated Subqueries are Evil and Slow. Or are They?
A common myth in SQL is the idea that correlated subqueries are evil and slow. For example, this query here:…
Read More » -
Software Development
NetBeans SQL Profiler – Take it for a Spin!
The upcoming release of NetBeans, currently in active development and testing, boasts plenty of new features. A few of them…
Read More » -
Software Development
10 SQL Tricks That You Didn’t Think Were Possible
Listicles like these do work – not only do they attract attention, if the content is also valuable (and in…
Read More »