I totally agree with the article, and all subsequent comments.

I'd like some debate, however, so I'd like to state 2 extremes, and ask where people's tradeoffs are?

1. Critical system,...

Convert(Varchar(10),CompetitorID) fails to order CompetitorIDs propery (because you'll get 1, 10, 2 etc..)

I tried it out and chrhedga's solution worked for me, but not Antares686's first part (as chrhedga suggested).

Here's...

Mohamed,

I'd be interested to know how fast it is if you use a table variable instead of a temporary table (assuming you can)...

DECLARE @rows int

DECLARE @subrows int

SET @rows = 12

SET...

Good article - it's interesting to see someone elses naming convention. Thanks Steve.

What about DTS packages and jobs? Does anyone have any naming conventions for those? We're...

I guess you could change your FROM situation to a WHERE situation by creating a view of the union of your similar tables (together with a flag to indicate where...

Good article. For case 1 you could use a function in sql 2000 to simplify the static sql to...

select * from authors WHERE au_lname IN (SELECT * FROM list_to_table('white,green'))

where...

Good article. I have 1 question...

Can someone please tell me what's wrong with this?

select

  State,

  UserCount = count(distinct c.UserID),

  ComponentCount = count(u.LocationID)

from

...