Blog Aggregator - Amardeep Sidhu

Some quick thoughts on the state of desktop virtualization tools…
Background
If you’ve been checking out my RAC articles, you’ll have probably noticed I’m a bit of a VMware fan. I originally used VMware Workstation, but switched to the free VMware Server when it was released in 2006. I don’t have much cause to complain about VMware […]

Robert Scoble just shared a link to Pencil Turns Firefox into a Drawing Tool, which points to the home of the Pencil add-on. It’s a pretty neat tool for drawing basic diagrams and prototyping screens.
Cheers
Tim…

Hancock was a bit of a surprise. It’s a story about a superhero who’s down on his luck and is looking for redemption. It was a genuinely funny movie that only descended into cornball cheese a couple of times. I knew nothing about the story before I went to the movie, so there were a […]

We hit an ORA-01450 error today trying to do online rebuild for an index in an unusable state. This was a non-unique index on a fairly large column — VARCHAR2(800 CHAR).

SQL> alter index i1 rebuild online;
alter index i1 rebuild online
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01450: maximum key length (3215) exceeded

It […]

So, how does one gather statistics on indexes? With InnoDB it’s one thing, with MyISAM it’s another thing. This post however, will focus on MyISAM. There are various ways, each having their own drawbacks and positive sides.
What about ANALYZE TABLE? It’s great — very fast in InnoDB. But with MyISAM a lock […]