William, not right now, but I'm considering turning the forum search back on.

If you pick the Active Threads on the left, that will get posts since your last visit. I usually scan for those with 0 or 1 response.

You can also pick...

Chris,

I can do that. We're in the midst of sorting the feeds out, so I've been waiting for that to change before I move things around, but I can easily...

OK, bring the ice back, clear, preferably Vodka ice and not black ice, and we'll trade!

Barely got out the driveway, so my prayers for the day were answered by 4L

PK doesn't do either. It doesn't help with speed or with inegrity. It tells you which column identifies data. You can set your unique index column to be the PK...

Do both people share the same employeeID? If so, then something's wrong. If not, then the WHERE clause is filtering it out.

The left join returns something like this:

1 ...

It sounds like corruption or perhaps a problem with the syscomments table.

My guess is DF_Serial_HQID" is a default on the table. If you check the table in SSMS, look for...

That could be it and if so, that's definitely a bug.

I'll try to check. I'm here so often, I've never paid attention.

Thanks for the visits, though 🙂

You need to better frame the question. What exactly about job opportunities are you asking?

My computer, Properties. Should give you the CPU type. Google that.

Hey, could make sense for consistency, all xxID columns as PKs.

I'd agree it's a waste of space, but you'd tinyint the StateID and it's not that much space, 50 bytes....

Mind sharing with us what you did? Not that I'd necessarily recommend anyone else follow your instructions from PSS, but I'm curious what might have been wrong and how they...

Actually it's an interesting question for an interview. If you have a lot of simple mode databases, then differentials could conceivably save you lots of resources on backups.

It's not crazy,...

Yikes, I appreciate your differences, won't discuss my beliefs, but no religion in the editorials!

Enjoy Christmas for what it's become: a holiday where we remember others and share goodwill with...

I'm getting slightly lost here, but I wanted to respond to Will a few posts above.

The problems with bad data are a good place TO require a PK, even a...