Great and very interesting question. Thanks Tom!

Easy one for this Monday morning, thanks! 🙂

Very confusing question, as it could definately be worded better.

The question asked for differences, but the answers were only statements about different properties of a unique index/constraint (what is a...

Very interesting question. But a lot of reading 😀

Thanks for the question.

Thanks Steve for the easy points and happy new year to you all!

Happy new year!

And happy birthday to Craig 🙂

If...

Maybe if you posted the actual execution plan, people can actually try to help you.

That must be some mistake...

W00t, easy question to close the year 😀 :w00t:

Not really sure though why a Microsoft resource is so necessary when the question itself is about a pretty universal concept.

Start with the 70-432 book, it's less advanced than 70-450. However, those books primarily focus on administration, and not on developing (TSQL et cetera).

You could also start with this book:

Microsoft®...

It seems your EmpID column is a string column instead of an integer column.

SSIS is not the tool for this requirement. You'd better check out mirroring or replication.

Which can be downloaded where?

CELKO (12/27/2012)

---

I guess PK means “NOT NULL PRIMARY KEY”, but a good SQL programmer never uses IDENTITY...