Do not put your logs on a single disk. Keep it as a hot spare, let performance suffer and someone will eventually spring for disks.

Hardware is cheap. You've probably blown...

Hard to say on that, but everyone seems to be recommending quad cores where possible.

Same OS/ SQL versions?

That sounds a little suspicious, but you've got less threads executing simultaneously, so it might make sense.

Yeah, offline would be better ;), didn't think of that.

I'd do autoclose or offline because that way the db still is on the server, it keeps it in your mind,...

sysobjects.uid

Profiler will do it. Autoclose is a quick and dirty way to check. Easy to scan logs, don't have to remember to turn it on, etc. If you're not experienced,...

Use the Unicode character instead?

Directly pick the character using CHAR(xxx) where xxx is the right code.

I've seen in the Scheduled Task items that if you schedule it to run for 2 hours, even though you say every hour, it only runs once or twice.

As for...

Are you running them all in the same batch in both situations?

You could try a stored proc instead and use WITH RECOMPILE.

I'd just change it, specifically so that things using it break and you change them to another account. As mentioned above, you shouldn't really be using this for much of...

We talked about diesels, but there are so few for sale. VW stopped the Jetta and we really wanted a 5 seater (to compare to the minivan).

The auto industry certainly...

The Zap is cool. I drove a Zebra and really liked it. If I was back at my old house, I'd seriously consider one. With 3 200lb guys in it,...

You can check sysccolumns for the one that appeared.

For the others, you could write query that would add up all the lengths in syscolumns, grouped by table, with a sum...

I won't recommend this, but I have worked in places where we've turned off servers to see if we got complaints. You're be surprised how many boxes can accumulate...

I compared to a mini-van since that was what we originally were thinking to buy. We wouldn't have gotten a Corolla since it's more cramped for a family of 5....