Yep. Formatting is best done in the client app. Always.

I suspect either will work. Testing is your...

I fixed it.

And yeah, I agree. After a...

It really does depend on the error, but you should look at the system_health extended event session. You can get errors there. Also, you can get queries that held...

There's no way to do this within the query, so what you have to do instead is set up a monitoring job. Start it at the same time as the...

Just as a straw poll, what if we had threads older than 1 year - latest post date <= dateadd (year, -1, getdate) - closed when someone tries to...

No.

You've got that all wrong. Jeff...

NVARCHAR for the win!

I've done database design by sitting with the developers and the business people, both. If you don't have full input, you're guessing. I really hate guessing. I get it wrong,...

Based on this, yep, I'm even more positive the right way to go is with a logical model and a physical model (or, minimum, a physical model). I've built databases...

What this is saying is that only one row in TEMP1 matches the join criteria, but three rows in LOG_DB match the WHERE clause. That's exactly how it's supposed to...

I don't completely understand what you're going for. Can you post table definitions and the query you're currently using?

When doing a database design, simply getting a list of columns is not how I'd pursue it. Instead, I want to understand what it is that they're attempting to store...

I don't think there's a single correct answer here. Is this a good time to consider schema's and your object layout? Yes. However, as you say, it's early in the...

Yeah. There really isn't a way to do this after the fact.