| Author |
Topic |
|
lee_h
Starting Member
36 Posts |
 Posted - 2003-03-20 : 21:51:28
|
| I've just worked out what this forum is for!It isn't so that you can talk crap and slag of MCDBA certs! It's so that you can increase your posting count... the crap is just a by product!!! |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-20 : 21:57:45
|
| and a place to blow off steam while giving people free support.What is your point ?Damian |
 |
|
|
lee_h
Starting Member
36 Posts |
Posted - 2003-03-20 : 23:32:43
|
| No Point, just wanted to increase my post count. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-21 : 13:22:38
|
| Hey me too!Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-22 : 20:20:17
|
| If you want to increase your post count...==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-22 : 20:26:14
|
.... then...or do you need a more detailed explantaion. .MCDBA is a valid qualification - just no substitute for experience.To pass it you need to know most things that are available but not when they are applicable.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-03-24 : 14:55:09
|
| Why is it that we read book after book, article after article it seems to go by in a blur …… Then we find ourselves in a situation and you scratch your head going where did I read how to fix this? I sometimes think sensory overload is a mainstay of the I.T. profession. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-24 : 21:00:40
|
| Not only is it sensory overload but also buffer overflow. I can still remember IP addresses of most servers that I supported at my last job (which was over a year ago now)! How do I get rid of this information? The answer: more beer!!!Tara |
|
|
|
Lavos
Posting Yak Master
200 Posts |
Posted - 2003-03-26 : 17:28:22
|
| Next time do what Einstein did. He refused to memorize piddly things like his phone number, or possibly his address, so he could be left to more important things. The trick is to not memorize them in the first place. Just know where to look it up at, and there is no reason to memorize.----------------------"O Theos mou! Echo ten labrida en te mou kephale!"So Long and Thanks for the Links. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2003-03-26 : 18:09:20
|
| So to put this in terms that we'll all understand ... all I really need is the foreign key to lookup my phone number rather than the phone number itself? Cool.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-26 : 18:20:06
|
| Yes. Identity seems like the obvious choice.Damian |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-26 : 18:20:51
|
quote:
So to put this in terms that we'll all understand ... all I really need is the foreign key to lookup my phone number rather than the phone number itself? Cool.===============================================Creating tomorrow's legacy systems today.One crisis at a time.
 Tara |
|
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2003-03-26 : 21:51:39
|
| Stick these tags on:"In case of kidnapping or amnesia, you'll find me at key value 12663265656."Sarah Berger MCSD |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-26 : 22:00:12
|
Reminds me of the stupid company a few years ago that tried to launch an alternate DNS business using phone numbers instead of names.They figured that 832 3836 2046 was easier to remember than mycompany.com because we already have to know phone numbers.And they wanted everyone to download a browser plugin to make it work.Ahhh, 1999...what a wonderful time  Damian |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-28 : 06:23:05
|
| Valid interview answers:Don't know - I always look in bol (preferrably with "but something like")I always copy this from one I've done before.Today I seem to have remembered charindex and patindex syntax but that's unusual.I was once asked what type of locks the server took when doing an update - fortunately they didn't know what really happenned and were expecting a one word answer. They gave up on that one after a few minutes of the something like bit.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-28 : 10:42:10
|
| Welcome to "Random Thoughts - The Inner Monologue of Nigel Rivett" |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-28 : 11:29:46
|
| Sorry - just got web access back after 4 days working in the wilderness.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-03-28 : 11:47:54
|
| I think the effects of some "warm and non-fizzy" beverages from that excursion into the wilderness have not fully worn off yet ...- Jeff |
|
|
|
|
I know why you're here!