SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Knowledge sharing


Knowledge sharing

Author
Message
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86358 Visits: 41098
David Burrows (11/27/2008)
And Jeff makes a good point too. Not enough of you guys get credit for posting knowledge...


Hear, hear. Smile

But I think we all owe thanks to folks like Jeff and Steve...


Ditto BigGrin

..... and don't forget ....

All hail Jeff, the SQL God w00t


Dang, David... heh... Thanks, ol' friend!

I've gotta disagree, though... if I were a "SQL god", I'd never make mistrakes. Tongue

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86358 Visits: 41098
Mannie, thanks for posting the article... your points are well taken and the appearance of the article is actually very timely for me. It gave me a chance to vent a little about a recent troublesome subject as well as a reminder that we all started out the same way.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Tim Mitchell
Tim Mitchell
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1795 Visits: 2988
Good article, and well articulated. On behalf of those of us who have been around a while, thanks for the kind words.

I'm sure that most if not all of us veterans could tell stories about the SQL server community, and this site in particular, as being a big help to us over the years. I found SSC after inheriting a single SQL Server installation and as I accumulated more of these instances to manage, I was able to call on this group for polite and professional advice many times. I've learned a thing or two since, and try to answer as many questions as I can - though I often stand in awe at many of the other experts here.

Not that I'm bashing other forums or other database technologies, but SSC has always seemed like a cut above other forum sites. I've participated in other SQL Server forums where many of the veterans put themselves on a pedistal, and will respond unprofessionally toward those who are inexperienced but willing to learn. And good luck finding helpful forums for some of the other database vendors. I've got a couple of Big O installations that I manage, and I've not had luck finding any forums that are anywhere nearly as useful as what we have here.



Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices


Ronald Cartmale
Ronald Cartmale
SSC-Enthusiastic
SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)

Group: General Forum Members
Points: 194 Visits: 203
I totally agree with Manie Verster and his article Knowledge Sharing. I have found sites like SQL ServerCentral invaluable and have scoured the many articles that have been posted here and at other sites.

I started programming in SQL some ten years ago and when I joined my current company I made the assumption that the developers all knew more far more than myself, but I soon realised from the headless chicken routines and sleepless nights that in fact they knew nothing apart from SELECT * etc.

Of course, a little knowledge is dangerous and buzz words would creep into our daily lives like indexes, triggers and colleagues started to use these in the belief that they were doing it right. It was only after one disastrous deployment that never got off the ground and the subsequent witch hunt to find the cause of the failure, that I was galvanised into really getting to grips with the SQL innards.

I was fed up with having little knowledge, the long hours and sleepless nights and through various forums I was soon able to trace the cause of many SQL / Server problems and to start advising colleagues on best SQL polices.

I spent hours trawling through help forums which I found many many times more helpful than the MSDN help pages which say a lot but tell you nothing, and which if you are not careful can be lead you a merry dance following link after link until you get so lost you give up.

Like Manie, I am a slow learner when it comes to written text, but I learn quickly from diagrams and worked examples something MSDN really lacks, but once I have learnt it is there to stay.

Long live the forums and a big thank you to all who have contributed over the years.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search