And, selecting more columns than you need may also cause high speed INDEX SEEKs to change to mere INDEX SCANs, not to methion the additional network traffic that selecting more...

Too bad that SET XML_SHOWPLAN ON doesn't work in SQL Server 2000, eh?

You really want to learn?  The best way to learn is to get good enough to teach.  The only way to do that is to practice.  The best way to...

First, thank you for the high compliment.

The thing that makes it "set based" is the fact that only the effect on a column was considered.  Yes, it appears that a...

It's the many that don't understand that we've run into in many a thread.  Between the two of us, it's almost like a standing joke... except it's not funny. 

You may have to limit the amount of memory each server uses because each is looking for 2 gig for a total of 4 gig... no room for the apps...

Seems to me, based on the chart that Matt posted and the low volume of your anticipated connection/data plans, standard edition would do.

I sure do feel for folks that get stuck in that type of situation.  Definitely not a pleasant position.   Was going to suggest you find a new company but you've...

Heh... maybe it figured out that you're breaking the license agreement and, therefore, the law by using the Developer Edition for production?

Heh... yeah... I did noticed that... easier for them to throw hardware at the problem even though that doesn't work.  Still makes them feel like they did something.

Oh yeah... almost forgot this... and speaking of "Thinking in Sets", Joe, you might want to include this in your new book... just because something is sans-loop, doesn't mean it's...

Yeah... how 'bout that?  I'm thinking that a couple of us on this forum should get together and write our own book... one that has some useful info

As a bit of a sidebar... why is it necessary to create a table named after a month and year???

NULL concatenated with anything is still NULL if the default setting of "Concatenate Null Yields Null" was left on... so this simple ditty will do the job you asked...

IsNull(@RbrComm+CHAR(13)+CHAR(10),'')

ETL the "code" to a spreadsheet?  Why would you do that?  You'd ETL the query results to a spreadsheet... not the code.

As I...