I think dcpeterson summed up this thread nicely in this statement:

My point about standards is that as they become more prescriptive, the odds increase, perhaps exponentially, that some of those prescriptions...

"If you always use word ID or CD after the field name, you always know that it is a primary/foreign keys."

Many of my customers use CD for codes that aren't...

Just to add some conventions I tend to follow..

User-created stored procedures are named usp_xxxxxx (this is a commonly used standard, but after reading this thread, clearly it's not used everywhere).

I use...

Great article, thanks for sharing it!  It's probably important to point out that it is the server's registry that is being used, rather than the client's.

Some info I left out:

Both machines are running SQL Server 2000 SP3.  The publisher is a WinXP box, the subscriber is Win2000 Server.  I'm using pull replication initiated from the...

Excellent article, thanks!

Noel,

That's refreshing to hear!  I think too many people throw out the baby with the bath water when it comes to cursors.  They have their place as long as they...

Thanks for the replies!  I have a few questions though:

Steve>The while loop versus a cursor operates in nearly the same way as the cursor.  Is it really more efficient or...

No, the example I provided showed a great example of the problem...

I figured it was something simple like that!!  Thanks for your help!!

Nice article, thanks for sharing your research!

Great article, but I'm thinking this is only the beginning.  Setting and querying the data is a start, but I would love to see a full solution where a script...

Nice article.  I'm glad the forum already beat me to asking the question about Oracle cursors.

Thanks for the followup, and great info!

JT

Great case study! 

I'd love to hear more about the steps you followed to perform the server trace when you were analyzing the script.  And also it would be helpful...