Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 20 of 26 total
Thread Optimising "not" clauses in SQL
Fri, Nov 20 2009 2:36 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Adam,

<< Thanks for the explanation. However, (just out of curiosity) if we were
to do a Query where Type='C' as opposed to "NOT C", wouldn't step 3 still
need to occur in this instance too? >>

No.  Remember, it's scanning the index, which doesn't include deleted
records.  It's only due to the flip of the bitmap that DBISAM is required to
scan the actual records also.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sun, Nov 22 2009 6:19 PMPermanent Link

"Adam H."
Morning Tim,

I hope you had a great weekend and this email finds you well. I had a
nice one. Went diving on an old 1878 shipwreck down at the coast.
Interesting bit of history...

> << Thanks for the explanation. However, (just out of curiosity) if we were
> to do a Query where Type='C' as opposed to "NOT C", wouldn't step 3 still
> need to occur in this instance too? >>
>
> No.  Remember, it's scanning the index, which doesn't include deleted
> records.  It's only due to the flip of the bitmap that DBISAM is required to
> scan the actual records also.

Of course - that makes sense. Thanks for your help, and explanations
mate - appreciate it!

Have a great week!

Adam.
Sun, Nov 22 2009 6:44 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Adam,

<< I hope you had a great weekend and this email finds you well. I had a
nice one. Went diving on an old 1878 shipwreck down at the coast.
Interesting bit of history... >>

Wow, that's pretty adventurous stuff.   Did you get any photos ?

Along this same vein, we're going to start up a "where in the world is..."
thing on the web site pretty soon, and it will basically be a situation
where we do a drawing every month for a free DBISAM/ElevateDB t-shirt and
then ask the winner to send in a picture of themselves wearing the t-shirt
in their location (or someplace interesting).  We've got some new
ElevateDB/DBISAM product logos on the way, along with a new company logo and
web site.  The new t-shirts are pretty cool also - all black with > 4-color
silk-screening.  We're also ordering up some cool new black baseball hats
and mugs.  At any rate, it sure would be cool to get a picture of a
DBISAM/ElevateDB t-shirt on a dive. Smiley

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Nov 23 2009 2:53 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

>and mugs. At any rate, it sure would be cool to get a picture of a
>DBISAM/ElevateDB t-shirt on a dive. Smiley

Yippee wet tshirt contests

Roy Lambert

ps only female developers need applySmiley
Mon, Nov 23 2009 3:03 PMPermanent Link

"Rita"

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:8137CD43-03F5-47C3-9293-1682D93D6DB5@news.elevatesoft.com...
>
> Yippee wet tshirt contests
> ps only female developers need applySmiley

U just wanna see my 44DD's with nipples like Mexican hats.
I refuse to join in this soft porno game until the guys strip. Wink

Rita

Tue, Nov 24 2009 2:45 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Rita


You really do not want to see me stripped!

Roy Lambert
Tue, Nov 24 2009 5:38 PMPermanent Link

"Rita"

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:67D04717-C11A-4E7F-9F6F-F019CA9C8212@news.elevatesoft.com...
>
> You really do not want to see me stripped!
>

No Roy forget it, I had an experience over the
weekend thats put me of guys forever well
older guys at least yukkkkkk.
Silly Kenneth thought he was a hospital case
with his erm nuts. After taking a peek it turned
out to be an ingrown hair underneath his ermm
nuts. OMG what was at onetime a nice taught
compact pouch has turned into a deflated old
fashioned type football inards that u blew up
it just dangled there yukkkkkkkkkkk
Rita

Wed, Nov 25 2009 2:01 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Rita


Thank you for sharing that with us Frown

Roy Lambert
Wed, Nov 25 2009 7:16 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Rita,

That was definitely the premier candidate for worst post ever. Frown

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Nov 25 2009 9:42 AMPermanent Link

"Dave Sellers"

Hey, well why not let that little old in-growing hair just carry on
growing-in?  Provided Kenneth lives long enough, that deflated football
inard may once more be as taut as an erm, football, or indeed the
coconut it may more closely resemble by then..

Can anyone come up with a SQL statement that might help poor Kenneth?

DELETE FROM SCROTUM WHERE HAIR = 'ingrown'

I think I should get out more....
« Previous PagePage 2 of 3Next Page »
Jump to Page:  1 2 3
Image