SQLfail

Musings on Oracle and life via the medium of SQL, every Monday and Friday

The problems with averages, part 1: there may be no data values equalling the mean

 Maths, Uncategorized  No Responses »
Apr 302012
 

 Posted by Chris Saxon at 08:00  Tagged with: averages, number of feet, select

Performance enhancing products

 Performance, PL/SQL  No Responses »
Apr 272012
 

 Posted by Chris Saxon at 12:00  Tagged with: bulk collect, creatine

ACID vs BASE

 Database concepts  No Responses »
Apr 252012
 

 Posted by Chris Saxon at 12:00  Tagged with: aicd, base, select

Complicated and slow queries? Try materialized views

 Performance  No Responses »
Apr 232012
 

 Posted by Chris Saxon at 12:00  Tagged with: materialized view, performance

Jetlag

 General nonsense  No Responses »
Apr 202012
 

 Posted by Chris Saxon at 08:00  Tagged with: analytics, flying, lag

The perils of select *, part 2

 Bad practices  No Responses »
Apr 182012
 

 Posted by Chris Saxon at 08:00  Tagged with: select star

The perils of select *, part 1

 Bad practices  No Responses »
Apr 162012
 

 Posted by Chris Saxon at 08:00  Tagged with: insert into, select star

The most significant exchange of your life

 Life  No Responses »
Apr 132012
 

 Posted by Chris Saxon at 09:00  Tagged with: alter table, girlfriend, partition, wife

Prepare the executioner!

 Bad practices, PL/SQL  No Responses »
Apr 112012
 

 Posted by Chris Saxon at 09:00  Tagged with: drop table, execute immediate, procedure

Isolation levels

 Isolation levels  No Responses »
Apr 092012
 

 Posted by Chris Saxon at 09:00  Tagged with: acid, isolation levels, select
 Older Entries

desc sqlfail

This site is a project to explain Oracle concepts (or other subjects that interest me) using simple SQL or PL/SQL statements.

If you'd like to know more about me you can do so here

If you'd like to get in touch, you can tweet me @chrisrsaxon

Follow Me

RSS

Popular posts this month

  • The NON-EXISTENT Edition
  • What has normalization ever done for us?
  • The infinite tuning trap
  • Where did all the decimals go?
  • One Database, One Package, Multiple Codepaths

Categories

Suggest an SQLfail

If you'd like to suggest a post, you can do so here

Tags

11g alter table analytics averages baby bitmap index blocking change management commit constraints create procedure create table create trigger cursors database design data warehouse date conversion delete dual explain plan flashback foreign key hints index insert into lag loops mental failing merge myths null package partitions performance pl/sql procrastination rownum select sequence table triggers update upsert wait events when others

Recent Posts

  • How do you move a table made of cheese?
  • A Tale of Two Models
  • The things that make life worth living
  • Where did all the decimals go?
  • The Crying Game

Archives

  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
© 2012 SQLfail Suffusion theme by Sayontan Sinha