Didn't see the Montana game, but yeah, that stings.

Brett Favre's win might have been mine, but I didn't see that one either.

Apologies. The original question was changed later by the submitter and I was supposed to switch around the answers. I've added back points for 3 and 4 answers.

osql from the command line with a script might be easier, but it's not T-SQL.

I think it would help, but are you talking about using other servers? Not sure you can have multiple publishers on one instance.

Agree. Call PSS and don't mess around with this data.

Let us know how it works. I put it on my laptop, but a little chicken to put it into production

Indeed. I'd think if you got over 10k tables you'd be asking for trouble.

You might have forgotten users. Search sp_help_revlogin on Google for the script to help you move users. It's an MS KB item.

Are all the tables indexed on the columns being referenced in the join? For example, is there an index on shipment.shipment?

Have you looked at the query plan to see what...

round()?

declare @i numeric( 6, 4)

select @i = 1.6025

select @i, round(@i, 2)

That's what I thought and no offense. The questions seem a little silly to me sometimes because I have worked with them for so long and you are questioning things...

I like "slightly denormalized" data for reporting, if it's a secondary data store and not a primary one.

I agree with David that this can become cumbersome, not only for deletes,...

Interesting thread. Space in the log or data file could be an issue. While SQL Server autogrows, all activity in the db stops, which can appear as "freezing up". this...

I haven't ever thought about distribution, but I have removed it from model. I don't want any guest permissions on servers, only those that I explicitly have setup.

If it breaks...

I saw a presentation about 4 years ago from a guy on hardware tuning. He talked about a few interesting things with disks. First was that you start to really...