Mark W the SQL Geek

Opinions, experiences and information about SQL and the databases that process the language, from a guy who's been at it for over 20 years.

Sunday, August 22, 2010

Oww...My Brain!

http://thedailywtf.com/Articles/A-Confusing-SELECTion.aspx

No need for further comment.
on August 22, 2010 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Pages

  • Home
  • Privacy Policy
  • Cookie Policy

About Me

My photo
MWrynn
DevOps Developer (and a sometimes backend dev/data eng/DBA depending when you catch me), passionate about SQL and evangelizing the subject. -- Big proponent of maximizing your database investment by taking advantage of the powerful features it has to offer. Big opponent of using your database as a generic, lowest common denominator bit bucket. -- Favorite phrase: "When in doubt, test it out." There's a lot of misinformation out there regarding SQL, especially performance claims. Anyone can test their favorite hypotheses by running a test! Yeah science!
View my complete profile

Blog Archive

  • ►  2025 (4)
    • ►  May (4)
  • ►  2024 (5)
    • ►  December (2)
    • ►  September (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2023 (3)
    • ►  November (3)
  • ►  2021 (1)
    • ►  May (1)
  • ►  2020 (3)
    • ►  August (2)
    • ►  January (1)
  • ►  2019 (9)
    • ►  October (1)
    • ►  June (4)
    • ►  May (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2018 (12)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  September (3)
    • ►  August (1)
    • ►  March (1)
    • ►  February (3)
    • ►  January (1)
  • ►  2017 (6)
    • ►  May (1)
    • ►  April (1)
    • ►  March (4)
  • ►  2016 (17)
    • ►  November (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (1)
    • ►  April (2)
    • ►  March (4)
    • ►  February (3)
    • ►  January (1)
  • ►  2015 (11)
    • ►  December (1)
    • ►  May (1)
    • ►  March (5)
    • ►  February (4)
  • ►  2014 (8)
    • ►  September (1)
    • ►  August (2)
    • ►  March (3)
    • ►  February (2)
  • ►  2013 (12)
    • ►  December (1)
    • ►  November (3)
    • ►  September (2)
    • ►  August (2)
    • ►  April (1)
    • ►  March (3)
  • ►  2012 (4)
    • ►  August (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2011 (24)
    • ►  December (1)
    • ►  November (3)
    • ►  September (1)
    • ►  August (2)
    • ►  July (1)
    • ►  June (4)
    • ►  May (3)
    • ►  April (3)
    • ►  March (2)
    • ►  February (2)
    • ►  January (2)
  • ▼  2010 (8)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ▼  August (1)
      • Oww...My Brain!
    • ►  June (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2009 (2)
    • ►  December (1)
    • ►  March (1)
  • ►  2008 (1)
    • ►  December (1)
  • ►  2007 (6)
    • ►  July (2)
    • ►  May (1)
    • ►  April (3)

Labels

  • 10
  • 11g
  • 12c
  • 12cR2
  • add column
  • alert log
  • Amazon
  • analytics
  • ANSI
  • apgdiff
  • api
  • argh
  • AskTom
  • auditing
  • awesome
  • AWS
  • big data
  • bind
  • bind variables
  • bonkers
  • BoobyTrap
  • Books
  • bug
  • caching
  • cartoon
  • cern
  • character sets
  • chat
  • clone
  • cluster
  • clustered
  • clustering
  • collations
  • column
  • column store
  • columns diffs
  • common table expressions
  • comparison
  • connor mcdonald
  • constructing rows
  • crazy
  • CTE
  • CTEs
  • danger
  • database of the year
  • db-engines
  • db2
  • ddl
  • default
  • diff
  • distinct on
  • dynamic columns
  • EC2
  • emacs
  • errors
  • evil
  • Evil MySQL Feature
  • example
  • expdp
  • export
  • features
  • foreign keys
  • game
  • generate series
  • generation
  • history
  • IGNORE
  • impdp
  • import
  • in
  • incremental refresh
  • independence
  • index
  • indexes
  • inheritance
  • INSERT IGNORE
  • installation
  • ISO
  • Java
  • JDBC
  • join
  • joins
  • JOOQ
  • JSON
  • just bind
  • key-value
  • length
  • limitation
  • linux
  • lisp
  • load balancing
  • locking
  • locks
  • logging
  • mandelbrot
  • maria
  • mariadb
  • MATCH_RECOGNIZE
  • materialized views
  • merge
  • microsoft
  • MODIFY
  • MS SQL
  • MSSQL
  • mwrynn
  • MySQL
  • MySQL.com
  • newlines
  • News
  • numeric
  • odd
  • online recovery
  • optimization
  • optimizations
  • optional
  • oracle
  • parallel
  • parameter
  • parameterization
  • parameters
  • paramterization
  • partitioned aggregates
  • partitioning
  • performance
  • pgpool
  • pgpool-ii
  • pi
  • pi day
  • pivot
  • pl/sql
  • postgres
  • postgresql
  • preparedstatement
  • query
  • query rewrite
  • quiz
  • random
  • rant
  • RDS
  • recovery
  • recursive
  • recursive query
  • reddit
  • reference
  • refresh
  • release
  • REPLACE
  • REPLACE INTO
  • reporting
  • retrosheet
  • rewrite
  • row
  • row constructor
  • row pattern matching
  • schema
  • scripts
  • sequences
  • series
  • shared memory
  • shmmax
  • sparkfun
  • speed
  • SQL
  • SQL injection
  • SQL Server
  • sqlplus
  • standard SQL
  • sucks
  • Sybase
  • syntax
  • table
  • test
  • Tom Kyte
  • trick
  • unpivot
  • upgrade
  • upgrading
  • upsert
  • usebindvariables
  • value
  • version
  • versioning
  • weird
  • whygod
  • window
  • window functions
  • windowing
  • with
  • with recursive
  • wonky

Report Abuse

Subscribe To

Posts
Atom
Posts
All Comments
Atom
All Comments

Followers

Search This Blog

MySQL metadata locks on child tables in foreign key relationships, and how Postgres compares

Popular Posts

  • The Benefits of Using Row Constructors! [MySQL]
      In the world of SQL, sometimes you need to conjure up rows of literal data out of thin air, instead of pulling data from an existing table...
  • Arrays vs. IN-lists in SQL Using JDBC: Techniques and a Glance Under the Hood
    Intro: Alright, so say you want to run a query that has the WHERE clause WHERE id IN (...) from your Java program, using JDBC, where the co...
  • What have Oracle Materialized Views got that PostgreSQL ones don't?
    This comes up once in a while. Just because DBMS x has a Feature ABC, doesn't mean it's the same as Feature ABC on DBMS y. Postgres ...
Watermark theme. Powered by Blogger.