| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
|
10-31-08, 16:11
|
|
Throwin' the steel to SQL
|
|
Join Date: Feb 2004
Location: Marina Del Rey, CA
Posts: 3,550
|
|
|
|
but don't take it the wrong way...It's not you, it's me...
__________________
aka "Paul"
Non est ei similis.
// Dear maintainer:
// Once you are done trying to 'optimize' this routine,
// and have realized what a terrible mistake that was,
// please increment the following counter as a warning
// to the next guy:
// total_hours_wasted_here = 13
|
|
10-31-08, 16:37
|
|
SQL Server Street Fighter
|
|
Join Date: Nov 2004
Location: Down The Rabbit Hole
Posts: 7,766
|
|
pulling out old favorites...
I still love you, but not in a romantic way anymore.
I think we might have a new game.
__________________
software development is where smart people go to waste their lives
|
|
10-31-08, 18:41
|
|
Throwin' the steel to SQL
|
|
Join Date: Feb 2004
Location: Marina Del Rey, CA
Posts: 3,550
|
|
|
|
I actually got a similar one.
I'll always love you, but I just don't LOVE you anymore.
__________________
aka "Paul"
Non est ei similis.
// Dear maintainer:
// Once you are done trying to 'optimize' this routine,
// and have realized what a terrible mistake that was,
// please increment the following counter as a warning
// to the next guy:
// total_hours_wasted_here = 13
|
|
10-31-08, 18:47
|
|
Empress of Ellipses
|
|
Join Date: May 2007
Location: Lost in Translation
Posts: 922
|
|
And there is always,
I love you and I want you to be happy. You just aren't happy anymore with me.
__________________
"Passion rebuilds the world for the youth. It makes all things alive and significant. ~Ralph Waldo Emerson
|
|
10-31-08, 22:37
|
|
SQL Server Street Fighter
|
|
Join Date: Nov 2004
Location: Down The Rabbit Hole
Posts: 7,766
|
|
there was a time when I saw us getting old together, but we have both grown as people and that person I thought I wanted to share my life is not the same person I want to share my life with now.
__________________
software development is where smart people go to waste their lives
|
|
10-31-08, 23:13
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,084
|
|
<arnold>
consider that a divorce
</arnold>
name that movie
|
|
11-01-08, 06:37
|
|
vaguely human
|
|
Join Date: Jun 2007
Location: London
Posts: 2,517
|
|
that must be total recal.
do i detecct a slight undercurrent of bitterness in the current thread?
|
|
11-01-08, 10:59
|
|
King of Understatement
|
|
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
|
|
I still love you, I'm just not in love with you.
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
|
|
|
11-01-08, 12:00
|
|
King of Understatement
|
|
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
|
|
Thought I would look some up on the web. How's about this one to really put a kink in your day?
Quote:
|
"I'm really sorry to have messed you about, but being with you has made me realise that I am gay and I can't string you along anymore."
|
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
|
|
|
11-01-08, 13:19
|
|
Resident Curmudgeon
|
|
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,307
|
|
Quote:
|
Originally Posted by r937
name that movie
|
I'm sorry Mr Quaid, I can't remember that one.
-PatP
|
|
11-01-08, 17:46
|
|
www.gvee.co.uk
|
|
Join Date: Jan 2007
Location: UK
Posts: 10,002
|
|
I still love you and want to be with you, I just can't be with you right now.
|
|
11-01-08, 23:12
|
|
World Class Flame Warrior
|
|
Join Date: Jun 2003
Location: Ohio
Posts: 11,556
|
|
You used to be sexy, but now you are fat and ugly.
__________________
If it's not practically useful, then it's practically useless.
blindman 
www.chess.com: "sqlblindman"
|
|
11-03-08, 07:04
|
|
www.gvee.co.uk
|
|
Join Date: Jan 2007
Location: UK
Posts: 10,002
|
|
"Have you run profiler against the app to confirm there's an ORDER BY clause on the query in question, and that it's ordering the correct columns?"
"No, but it should be ordering it by the primary key"
"uh-huh, but why don't we check for an ORDER BY clause first?"
"I'm telling you, it has *always* ordered it correctly, why would it suddenly decide to change?"
"Have you applied any new indexes to any of the tables involved in the query?"
"Yes, but I don't see what that has to do with it. I'm only selecting two fields and one of them is the primary key from one of the tables, it should order by that!"
*face-palm*
Seriously, I could have sworn I hammered the point home last time this happened.
|
|
11-03-08, 07:07
|
|
King of Understatement
|
|
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
|
|
TRWTF is applying an order by to the SQL in any event. WTF? WTFF? WTFFF??????
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
|
|
|
11-03-08, 07:23
|
|
www.gvee.co.uk
|
|
Join Date: Jan 2007
Location: UK
Posts: 10,002
|
|
I came up with an example that works with just 2 sample rows to show why you cannot rely on order and I think this chaps head was about to implode when he saw the results...
This is the same person who "designed" and implemented the index strategy for this system.
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
The Yak Corral III
