Thanks for your responses! It may seem like minutiae, but it's things like this I need to know before building on that knowledge to something more important. 🙂

DBA From The Cold (10/3/2014)

---

How are you rebuilding the indexes?

Say for an index with 2 pages, if the rebuild does not put those two pages next to each other (for...

Why doesn't Rebuild put the index into its own extent...

CELKO (10/2/2014)

---

No, not usually. Think about manufacturing processes. VIN, ISBN, et...

Natural Keys have a tendency to take inserts all over their spectrum. This fragments indexes very quickly, and unnecessarily.

Setting a PK as a surrogate key obviates the need to insert...

It's a mistake to not compare apples to apples.

MERGE offers a single statement for the Update/Insert. To fully quantify its benefits, you must also include the "failure" case, where a...

Thanks for the reply! Sure looks like a bug, but yeah, referencing column inside has to be available. Not a bug, but sure does stink. ><

Any other suggestions?

I can handle the no-dupes thing from the application - that's how I'm doing it now. A better solution would seem to be a database constraint of some kind, but...

I don't think much has changed... At all. Every generation has always thought that the next generation was a bunch of slackers, whereas THEIR generation is the only one that...

I disagree with the entirety of your response. It is not arrogance to point out the utterly poor quality of the article. This is SQLServerCentral.com, not night school. The terrible...

Frankly, I found the article utterly unreadable. These aren't typos - this is a fundamental lack of grasp of the language... A language that is at the core of T-SQL....