Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Site Related Forums

The Yak Corral

A new DBA on the way!

Author

Topic

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-26 : 10:08:04

Evidence found here for arrival last week of November!

Peter Larsson
Bjuv, Sweden

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-26 : 10:13:30

CONGRATULATION PETER !

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-26 : 10:15:12

Guess you should be busy with your new DBA rather than saving lost

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-26 : 10:24:06

I didn't understand what the picture is about?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-26 : 10:26:45

quote:
Originally posted by harsh_athalye

I didn't understand what the picture is about?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Guess you are still single

[HINT] : it's the result (not the query result)

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-26 : 10:28:56

Picture is little shaky, as I were when taking the photo

Peter Larsson
Helsingborg, Sweden

X002548
Not Just a Number

15586 Posts

Posted - 2007-03-26 : 10:29:41

and celibate...

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-26 : 10:30:02

quote:
Originally posted by Peso

Picture is little shaky, as I were when taking the photo

Peter Larsson
Helsingborg, Sweden

You must be too excited. Is this Primary DBA ?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-26 : 10:34:03

Yes! In this joint venture.
No. Have a junior DBA with 3 year experience with former (disaster) alliance.

Peter Larsson
Helsingborg, Sweden

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-26 : 10:40:12

I think I got you.

Are you becoming a proud father of a baby?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-26 : 10:49:52

Very much so!

Peter Larsson
Helsingborg, Sweden

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-26 : 11:21:43

Congrats !!!

Then its definitely worth celebrations!

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-03-26 : 12:39:08

CONGRATS PETER!!!

you optimezed your joins well

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-26 : 12:41:14

JOINs? Ahhh. Yes

I first thought you wrote LOINs

Peter Larsson
Helsingborg, Sweden

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-26 : 12:46:02

The query must have performance well with the optimized joins

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-03-26 : 13:03:20

and LOINS

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

maya_zakry
Constraint Violating Yak Guru

379 Posts

Posted - 2007-03-26 : 21:42:02

wow congrats, sagitarrius dba junior

~~~Focus on problem, not solution~~~

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2007-03-27 : 06:31:37

Wow, that's so cool Peter...congrats on the ultimate full inner join

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2007-03-27 : 07:07:28

[code]
SELECT
H.Kid
FROM
Peter P
INNER JOIN
Spouse S
ON
P.Ychrom = S.Ychrom
LEFT JOIN
Hospital H
ON
(P.chromosomes + S.chromosomes) = H.kid
WHERE
H.birthdate BETWEEN '20071120' AND '20071130'[/code]

Yes I am bored and tired this morning.
Hearty congratulations Peter!

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-27 : 07:22:01

Thank you! Very clever query

Peter Larsson
Helsingborg, Sweden

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-03-27 : 12:57:08

Congratulations on the new version.

************************
Life is short. Enjoy it.
************************

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources