I tend to agree with what's listed above, but I'd be careful about not allowing reuse and using things like phone or email as PK values.

I have had re-used emails,...

I was quite a sight...

Kit G (7/16/2010)

---

Grant Fritchey (7/16/2010)

---

To know for sure you'd need to consult a lawyer. But since it's a non-exclusive license, I'm pretty sure that means you retain copyright. Just make...

I think his initial argument seemed to be that the way he was upgrading his code (lower stack stored procedures) to the new error handling resulted in changes. It's valid,...

Lynn Pettis (7/16/2010)

---

Grant Fritchey (7/16/2010)

---

Lynn Pettis (7/16/2010)

---

I guess some people think it isn't unprofessional to call someone stupid in professional site such as SSC.

I hope I wasn't ambiguous in my...

I emailed the guy, asking him to watch his language, and querying what he thought his boss, or his next interviewer, might think about his tone.

Not sure it will help,...

What do you mean you "switched" a server? I assume this is physical to virtual, but perhaps you can provide more details?

One of the things that bites people at...

How are the records changed? Is it any Access db that updates them?

I'd set up a job that exports this stuff to a known, off server location. That way you...

Apologies, we must have had a scheduling error out there. Still, a free point for everyone.

Just wondering if this has fallen off everyone's radar?

http://sqlservercentral.sharepointspace.com/

Jeff Moden (7/15/2010)

---

I'd put it a bit stronger than that: there are cases where using a sequence table is appropriate and a column with the IDENTITY property is not a...

That is a funny thread actually. I can see the frustration building, and it is tempting to jump in. IMHO, the original code is just shitty coding, and a bit...

Makes no sense to me. A diff is used to reduce recovery time from logs and speed the backup impact since it should be shorter than a full. However since...

You can select from the openquery

select * from openquery(...)

http://msdn.microsoft.com/en-us/library/ms188427.aspx

Best of luck, and looking forward to reading more.

A few pieces of advice:

- praise in public, criticize in private, even in the team.

- bad things are your fault, good...