I strongly agree with NoelD and Kieth Henry - Access Data Projects (.adp) is the way to go for a number of reasons.

One of them is that each linked table...

>>One more interesting tid-bit, You can reference the Global variable either by it's name (as shown above) or it ordinal value (oDTS.GlobalVariables(1).Value...1 indexed).<<

Hi jg4 - The reason you can use the...

Nick - I very much agree with Don Peterson's comment - a very good article except for the suggestion to consolidate lookup tables. Don's article, for which he provides a...

Jeff, you have expressed more eloquently and in far less words my frustration with ISO-11179... and I only read Part 5 - the part about naming conventions!

I'm still not ready...

Hi Andy,

I get so much out of SQLServerCentral.com - so I'm fine with this change - it's more than worth it to find an extra couple of emails in my inbox...

I keep finding more gems in this great tool, Query Analyzer. Here are two additional tips:

1. With the default settings, using the Object Browser for scripting creates what is for me...

Wow, SQLServerCentral.com now does mind-reading!

I was ready to add my 2 cents to this thread, when I noticed that my post to a similar thread from August 2002 was already there!!

Best...

Joe,

I downloaded the ISO standard and read Part 5, "Naming and identification principles for data elements."  Thank you very much for cluing me into this - it wasn't even on...

OK, I just did a few minutes surfing, and Joe does have a lot of worthwhile things to say about coding standards and readability out on the Web.

I suggest, for...

Hey Joe, why don't you tell us how you really feel!?  <g>

I can report from my own experience that I do find T-SQL written by others in a style similar to what...

Bravo, Steve!  I think of myself as already using good coding standards (almost all the same as yours,) but in fact, you showed me a few things I hadn't thought...

Thanks for the info, Dan -- it's good to know that text columns haven't given you any problems.

Combining your input with what Jeff said, it sound that as long as...

Hi Corie,

You're absolutely right - looking at a specific table with two of these varchar(4000) columns, if found that the average length for one column was 383 and for the...

Jeff and Julian - thank you for your insight!

>>If you are worried about the I/O, make sure your data list is only selecting the columns and rows it needs from the...

Thanks again for another thought-provoking article, Andy.

I wouldn't market myself a DBA, because I don't know quite enough about the guts of SQL Server. Maybe "Deputy DBA" would be appropriate....