The performance is nicely summarized above and it's really a good debate. But the answer is that it depends.

I know, that sucks. But it depends on how you architect things....

Latches are lightweight locks. Typically I wouldn't worry about them, but if there is contention, then they are something to look deeper at.

The problem is there are many things to...

Just monitor. I'd look at CPU, buffer cache hit ratio, memory reads/sec, user connections, transactions/sec, disk i/o reads and writes.

Once you have data, you'll have an idea of what's normal...

Even if there are no complaints, it's likely that your application will outgrow the server hardware over time. Data sizes grow, more users, things just happen that will cause issues.

So...

Sorry.

The big problem with triggers outside the database is that they're inside the transaciton that fired the trigger. so delays escalate locks and blocks. Transactions should be tight and sending...

What's the structure mean? Is EmailID somehow related to threadID or are you just ordering by the threadID.

Why not just order by threadid desc?

I have heard some people say that RAMDISKs work great and love them. That's an interesting idea, maybe drop a separate database up there, same rights, security, and move the...

How long were you waiting?

I started this reply at 7:37amMDT, pushing "Post" at 7:50am MDT

It's something to think about.

We're hesitant to change the forum code too much. We touched a bunch of stuff last time and it made upgrading impossible over time to fix...

We are looking to expose this in other ways, probably through your account page. It takes time and we have a few other priorities, but we'll get this done.

There are two other things I thought up since the last post.

1. You might have a virtual log file at the end of your log file that prevents it from...

First, don't back up to tape. Back up to disk and then move to tape.

second, it sounds like your job has a problem with the backup set. Can you post...

sp_change_users_login should work in 2005 still. Look it up in the doucmentation.

If you add a table to the database, data or not, the log data increases. This a logged event and something is written even in simple mode.

I'd like to hear...

I think Nigel has a great explanation. It definitely depends on the context in which you are discussing things.