Success is about Imagination

Ignite Your Passion

kyle Hailey

Jun 26, 2009
1 min

SQL Joins

Growing up on Ansi 89 and working at Oracle for 10 years, some of the the cleaner SQL join notation seems new to me. Here is a great...

17 views0 comments

kyle Hailey

Jun 10, 2009
1 min

SQL Videos

More videos from Stéphane Faroult I have yet to go through these videos but based on the previous two I posted from Stephane, these...

3 views0 comments

kyle Hailey

Jun 5, 2009
1 min

Finding the problem is the hard part

Interesting blog on how finding performance problems takes 80% of the mean time to resolution. Sybase ASE Performance and Tuning This is...

21 views0 comments

kyle Hailey

Jun 4, 2009
1 min

Types of subqueries

Types of subqueries (today I couldn’t think of the term “inline view”) subquery ( subselect used in where clause) correlated subquery...

3 views0 comments

kyle Hailey

Jun 4, 2009
1 min

Stephen Faroult on Tuning SQL

One of the main things I do to tune SQL is to encourage the optimizer to take path. I often take the most important steps to do first and...

7 views0 comments

kyle Hailey

Jun 1, 2009
1 min

Correlating SQL to Procedures

Starting in Oracle 10.2.0.3 (ie not 10.2.0.2 and below) it’s easy to track what package and/or procedure a SQL execution came from using...

9 views0 comments

kyle Hailey

Jun 1, 2009
1 min

Stephan Faroult’s Videos

I love this video on “getting dreadful database performance” by Stephan Faroult. The video is hilarious and infomative:...

9 views0 comments

kyle Hailey

May 15, 2009
1 min

"kksfbc child completion"

I’ve run into the wait “kksfbc child completion” a few times over the past but found very little written about it. I don’t have an...

13 views0 comments

kyle Hailey

May 12, 2009
1 min

Concurrency Testing

One complaint I’ve heard of a number times is how code gets tested with one user and it runs fine and then gets put into production and...

9 views0 comments

kyle Hailey

May 11, 2009
1 min

To Pie Chart or not to Pie Chart

I’ve always had a natural aversion to pie charts. Pie charts seem all the less apealing when compared to bar charts. I’ve wondered if it...

4 views0 comments

kyle Hailey

May 8, 2009
1 min

SQL*Net break/reset to client

Another problematic wait event in Oracle is “SQL*Net break/reset to client”. This wait event typically happens when there is something...

43 views0 comments

kyle Hailey

Apr 30, 2009
2 min

Lock Waits: Finding the blocking SQL on Oracle

One of my pet peeves on Oracle is the inability to find out what SQL took out a lock that another user is waiting. It’s easy to find the...

13 views0 comments

kyle Hailey

Mar 11, 2009
11 min

How to be a program manager

I’m the “Program Manager” for DB Optimizer at Embarcadero, thus I found this article fascinating about the role of a “Program Manager”:...

11 views0 comments

kyle Hailey

Mar 5, 2009
1 min

Welcome to DB Optimizer Blog

A blog to compliment the information site at http://sites.google.com/site/embtdbo/

0 views0 comments