Dear Experts!! - SQL Server Forums

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

Dear Experts!!

Author

Topic

maya_zakry
Constraint Violating Yak Guru

379 Posts

Posted - 2007-03-22 : 21:53:02

hey sql experts out there!
just curious, how did u all start.. what's yur first query? how long u've been doing sql.. and how come master it so quick??.. and last Q :- dont u all have anything else to do than 24 hrs answering all posts? anybody get paid? are you sql support staff or just some kind of devoted volunteer??

.. this forum is really a good thing, honestly.. i think i solved 70% my sql prob here.. :P

Reward My Curiosity

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

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-22 : 22:05:42

"how did u all start"
for me, I click on the START button

"what's yur first query?"
select 'Hello World'

"how long u've been doing sql"
around 5 years

"how come master it so quick??"
have not mastered it yet. Still learning. Still have a lot of area then have not really touch on in SQL 2000 and now SQL 2005 is out.

"dont u all have anything else to do than 24 hrs answering all posts?"
Yes. I have. But i can't says the same about Peter

"anybody get paid?"
Not me

. I thought the previous Q is the last Q ?

"are you sql support staff or just some kind of devoted volunteer??"
No. I am just a SQL

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-22 : 22:07:34

Oooops. Sorry I shouldn't be answering this thread. I just noticed the title. It wasn't directed to me

maya_zakry
Constraint Violating Yak Guru

379 Posts

Posted - 2007-03-22 : 22:16:00

yes u are..
u answered 50% of my Q :- here's my list of regular experts who solved most of my queries and even speed up, enhance, simplify my long ridiculos code :-

khtan : always be the first one to amswer posts and solved it stret away, with good samples and explaination
peter : this man must be crazy.. enhance my speed of SP, porpose brilliant method and algorithm and function.. blablabla, but i think he has no idea why cant newbies understand his workable code
harsh : simple, accurate
madhivanan : long time no see

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

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-22 : 22:21:17

I guess i am the nearest

maya_zakry
Constraint Violating Yak Guru

379 Posts

Posted - 2007-03-22 : 22:26:54

yup an oldtimer yak u are...
and what is yak has to do with SQL? ha ha haaaa....

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

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-22 : 22:39:21

see http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61012 for more info on

maya_zakry
Constraint Violating Yak Guru

379 Posts

Posted - 2007-03-23 : 01:43:49

hey, what a cute yak icon...

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

maya_zakry
Constraint Violating Yak Guru

379 Posts

Posted - 2007-03-23 : 01:55:49

any female yak icon?? wonder if the female got horns or not?

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

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-23 : 04:13:17

from Wiki

quote:
Both males and females have horns

http://en.wikipedia.org/wiki/Yak

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-03-23 : 05:49:30

"how did u all start"
started as a c++ developer 6 years ago.
got pissed over a slow query 4 years ago. read about SQL and optimized it's ass off

ever since i've been hooked.

Unlike .net which is more or less an exact science, i think about sql as an art.
in SQL you can't say steps 1 to 5 will do the exactly the same thing on every server.
the correct answer is always: it depends.

"what's yur first query?"
i have no idea anymore

"how long u've been doing sql"
around 4 years

"how come master it so quick??"
as i said SQL is an art form so you can't master it. you can only get better and better

"dont u all have anything else to do than 24 hrs answering all posts?"
well personally i have sqlTeam active topics opened throughout my work day and it refreseh the topics every 5 minutes.
i look at the forum about once every half an hour.

"anybody get paid?"
nobody here gets paid.

"are you sql support staff or just some kind of devoted volunteer??"
not even close.
there are some people from sql server product team that monitor the forum but that's it...

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

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2007-03-23 : 07:51:47

Art form mmmmmmmmmmmmmmmmmm

Ok Who is Picasso and who is Leonardo da Vinci???

Jim
Users <> Logic

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-23 : 07:59:34

Picasso?
I don't know who was that?
But I know google provides free software called Picasa to organize your photos...So I guess Picasso has something to do with photos...may be he was internationally acclaimed photographer !

Leonardo da Vinci?

No idea...But I recently read a book called Da Vinci code...so I guess this person is/was code breaker or cryptographer may be..!

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-23 : 08:15:49

"how did u all start"
I wrote my own database engine in the mid 80's with Borland Pascal.

"what's yur first query?"
GET DATA FROM ALL COLUMNS USING TABLE Test

"how long u've been doing sql"
15 years

"how come master it so quick??"
Have only begun. Master sql? I am just lucky...

"dont u all have anything else to do than 24 hrs answering all posts?"
My bot is doing my work for me at SQLTeam.

"anybody get paid?"
Only for articles.

"are you sql support staff or just some kind of devoted volunteer??"
No. I am just a SQL

.

Peter Larsson
Helsingborg, Sweden

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-03-23 : 09:11:25

quote:
Originally posted by JimL

Art form mmmmmmmmmmmmmmmmmm

Ok Who is Picasso and who is Leonardo da Vinci???

Jim
Users <> Logic

Teenage Mutant Ninja Turtles?

CODO ERGO SUM

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-23 : 09:50:53

"I wrote my own database engine in the mid 80's with Borland Pascal."
Is it called Prequel ? Peter-SQL

X002548
Not Just a Number

15586 Posts

Posted - 2007-03-23 : 11:04:24

quote:
Originally posted by maya_zakry

hey sql experts out there!
just curious, how did u all start..

The need to eat

quote:

what's yur first query?

SELECT * FROM Table

quote:

how long u've been doing sql..

Jurassic period

quote:

and how come master it so quick??..

quick? Icebergs melt fatser

quote:

and last Q :- dont u all have anything else to do than 24 hrs answering all posts?

Well, yes, but it's not as interesting

quote:

anybody get paid? are you sql support staff or just some kind of devoted volunteer??

Paid? We're suppose to get paid?

quote:

.. this forum is really a good thing, honestly.. i think i solved 70% my sql prob here.. :P

Thanks Mr. Bill!!!!!!!

Reward My Curiosity

~~~Focus on problem, not solution~~~
[/quote]

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

Kristen
Test

22859 Posts

Posted - 2007-03-23 : 11:23:35

"I wrote my own database engine in the mid 80's with Borland Pascal."

Pah! I did that back in the '70's in Basic .... but I expect someone here did in tablets of stone in a cave back before Pontious was a Pilot ...

Had Referential Integrity with Attributes ... perhaps I should patent that and sell it to MS ... but the 1st-normal-formers would no doubt object.

The FK could be established with a given value for a column, so a single table of "lookup codes" with an "attribute column" was used by all simple lookups. Each table had its own file, and lots of files = slow ... so needs-must. There was also a "conditional attribute" - so depending on the value of a column (in the "many" table) a different "attribute" could be matched (in the "one" table); when that was migrated to SQL Server we added a "Ad-hoc addition to ON clause in the JOIN" to allow even more "loose" R.I. ... the R.I. could also enforce 1:1, and had the ability to define an "Item" column in the Child record - so that, for example, an Order Item would automatically get the next available ItemNo [for the current OrderID].

Yeah, the 1st-normal-formers will be having a fit!

But, Hey!, I had already decompiled the basic interpreter and reused the space taken up by the useless TRIG functions for some Date handling extensions to Basic ...

Kristen

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-03-23 : 11:29:29

silly Kristen bot...

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

jhermiz

3564 Posts

Posted - 2007-03-23 : 11:38:30

quote:
Originally posted by maya_zakry

hey sql experts out there!
just curious, how did u all start.. what's yur first query? how long u've been doing sql.. and how come master it so quick??.. and last Q :- dont u all have anything else to do than 24 hrs answering all posts? anybody get paid? are you sql support staff or just some kind of devoted volunteer?? .. this forum is really a good thing, honestly.. i think i solved 70% my sql prob here.. :P

Reward My Curiosity

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

Nice vocab! How about an english course after your sql course ?

Programmers HowTo's -- [url]http://jhermiz.googlepages.com[/url]

maya_zakry
Constraint Violating Yak Guru

379 Posts

Posted - 2007-03-23 : 21:37:31