SQL

DZone Daily Dose - 2009/11/14

If Oracle were to sell MySQL to a third-party, who would it be?  Many thought Red Hat was the obvious choice with thier JBoss open source division. ...

0 replies - 2573 views - 11/14/09 by Mitch Pronschinske in News

Migration tool SQL Ways reaches 4.0

A new version of SQL Ways has just been announced by Ispirer Systems.  SQL Ways converts embedded SQL and database API without having to extract SQL...

0 replies - 699 views - 11/03/09 by Mitch Pronschinske in News

DZone Daily Dose - 2009/10/28

Amazon says it will cut prices on its core EC2 cloud services starting November 1st.  You can tell they are getting anxious about the impending release of...

0 replies - 1916 views - 10/27/09 by Mitch Pronschinske in News

NetBeans 6.8: A Few of Your Favorite Things

"Raindrops on roses and whiskers on kittens" didn't make the cut, but what are a few of your favorite things about the upcoming NetBeans 6.8?  DZone...

4 replies - 13050 views - 10/26/09 by Mitch Pronschinske in News

Could the EU Block the Oracle-Sun Deal?

This week the European Commission expressed its displeasure with Oracle's lack of cooperation in the antitrust probe surrounding the Sun acquisition. ...

3 replies - 2154 views - 10/22/09 by Mitch Pronschinske in News

NoSQL – A Fluid Architecture in Transition

Lot of talk about NoSQL. Much of it well deserved. And while lot of the excitement around it is well understood by those in the know, some of it may actually...

0 replies - 765 views - 10/22/09 by dnene in Articles

Computing 95 Percentile In MySQL

When doing performance analyzes you often would want to see 95 percentile, 99 percentile and similar values. The "average" is the evil of performance...

0 replies - 2872 views - 12/03/08 by PeterZaitsev in News

ANALYZE: MyISAM vs Innodb

Following up on my Previous Post I decided to do little test to see how accurate stats we can get for for Index Stats created by ANALYZE TABLE for MyISAM and...

0 replies - 2898 views - 09/11/08 by Schalk Neethling in News

Podcast: Writing LUA Scripts for MySQL Proxy - MySQL University

This session will introduce the basics of the Lua language, with particular emphasis on the features of immediate use with MySQL Proxy. The lecture will...

0 replies - 2354 views - 09/08/08 by Schalk Neethling in News

How to find duplicate row in a table - MSSQL

The below given query will fetch the duplicate rows in MSSQL with number of occurance of each row.SELECT <all column names - comma seperated>,...

0 replies - 2300 views - 09/01/08 by arunbiji in Tips and Tricks

How adding another table to JOIN can improve performance

JOINs are expensive and it most typical the fewer tables (for the same database) you join the better performance you will get. As for any rules there are...

1 replies - 3644 views - 08/14/08 by Schalk Neethling in News

Rapid Application Development for Content-Rich Applications

0 replies - 3451 views - 07/29/08 by Matthew Schmidt in Whitepapers