| Author |
Topic |
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
 Posted - 2006-07-04 : 09:07:55
|
| I have a crap memory, there's no hiding from that. And I'm really bitter about the number of books and REALLY REALLY hard work I put into remembering sql statements, functions, methods, etc and later forgetting them. I'm constantly having to relook something up over and over.It may be that in 2 years of DBAing, I might not need to create a trigger, or a function. So, those that can come up with say a trigger, or complex sql statement in a few minutes, how do you remember it all? Are you using it all every day?Drew |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-07-04 : 09:16:05
|
| Some ideas:-- U can use the teplates, wizards etc-- U can create ur own document with samples, and properly document it-- U can go / search in the web (Google), discussion forums ...-- Or try to remember those by doing frequently.Srinika |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-07-04 : 09:19:09
|
i still have to go look in BOL how to create a fuinction or a trigger... so don't worryIt's not what you remember it's what you can find. And how fast  Go with the flow & have fun! Else fight the flow  |
|
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-07-04 : 09:20:21
|
| Oh, I do all of the above except the frequently bit.What about you guys? How many times do you have to so something before you no longer have to look it up? |
|
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-07-04 : 09:21:47
|
Really?Oh, that's so good to know.quote:
Originally posted by spirit1
i still have to go look in BOL how to create a fuinction or a trigger... so don't worryIt's not what you remember it's what you can find. And how fast Go with the flow & have fun! Else fight the flow
|
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-07-04 : 09:27:03
|
| in SS2k5 it turned out i discovered a new added feature when going to check up on the delete syntaxthis is what i found:http://weblogs.sqlteam.com/mladenp/archive/2006/06/08/10122.aspxso i guess it's good to forget something once in a while... Go with the flow & have fun! Else fight the flow |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-07-04 : 14:29:24
|
| Let's see if I recall..To really remember something:0. Learn/memorize X1. In memory rehearse/repeat X after 5 minutes2. In memory rehearse/repeat X after 30 minutes3. In memory rehearse/repeat X after 3 hours4. In memory rehearse/repeat X after 3 days5. In memory rehearse/repeat X after 3 monthsAfter that you will never forget.rockmoose |
|
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-07-04 : 15:44:41
|
| You are kidding , right? |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-07-04 : 17:19:48
|
| Hey Drew,It might be a good technique to remember things, why not!?I peruse the documentation quite a lot, some things seems to stick easily and some things I just have to look up every time.So you are in good company.For me writing ALL the sql by hand and not using any graphical tools for the administration has in time helped me a lot,both in learning more and working faster.rockmoose |
|
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-07-04 : 19:39:14
|
quote:
Originally posted by rockmoose
Hey Drew,It might be a good technique to remember things, why not!?I peruse the documentation quite a lot, some things seems to stick easily and some things I just have to look up every time.So you are in good company.For me writing ALL the sql by hand and not using any graphical tools for the administration has in time helped me a lot,both in learning more and working faster.rockmoose
|
|
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-07-04 : 19:49:50
|
quote:
Originally posted by rockmoose...so you are in good company. For me writing ALL the sql by hand and not using any graphical tools for the administration has in time helped me a lot, both in learning more and working faster.
You're so right. It's just a matter of discipline. I frequently tell myself, "Drew, today you're not touching the mouse". But then I find I'm in such a rush to do things, I end up using EM. So that's it! From as tomorrow, I'm only using SQL!...(again). |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-05 : 02:38:02
|
for the actual syntax, I tend to forget the exact parameter name or the other of the parameters in functionsbut the important thing is I do know what I want to use...I did create a small admin apps where I incorporated all my routine and usual tasks so I don't have to memorize everything  , this gives me the freedom to browse and manage all the sql servers and propagate 'global' changes --------------------keeping it simple... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-07-05 : 05:07:28
|
| Isn't it easier to just ask the question on SQL Team and have someone with a better memory write it for you? Kristen |
|
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-07-05 : 05:21:37
|
No.  That's what's pissing me off! It takes me ages to remember something, and then I post it here and get a 2 page response in about 3 minutes! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-07-05 : 05:24:37
|
| "and get a 2 page response in about 3 minutes!"QED |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-07-05 : 05:25:12
|
| HAHAHHA! Exactly 3 minutes - how about that (sorry about the lack of a 2 page response!) |
|
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-07-05 : 06:11:45
|
Very good.  Drew aka The Drewster |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2006-07-05 : 13:21:48
|
| You want a good answer...I look at SQLTeam as a learning experience...if I don't know something I see posted, I set out to figure it out...and provide examples of actual wroking code....and I do this for the same questions asked over and over and over....got to a point where I figired out some more involved stuff, I'd blog, so I don't have to remember....Lot's of good stuff in those blogs out there too...Tara's got a boat load of stuff...Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-07-05 : 14:54:45
|
quote:
Originally posted by X002548
Lot's of good stuff in those blogs out there too...Tara's got a boat load of stuff...
How bigs this boat? And where can I find it?...Drew aka The Drewster |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-07-05 : 15:49:35
|
| I'm with Brett on this. If I see something I don't know on SQLTeam, I learn it. That's how I get exposed to all sorts of stuff that I normally wouldn't see on a daily basis. I can tell you how many times I've run into a problem, and remember seeing the solution to a similar problem on SQLTeam.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
Next Page
|
What next?!