Grant Fritchey (7/23/2014)
I see what everyone is saying and I don't disagree with them, but I know where Brandie is coming from. You make compromises in order to make things work well. In a perfect world we'd have nothing but perfect designs running perfect code and that would be awesome. Meanwhile, back on planet Dirt, you do what you need to do to get through the day successfully. Aim for the perfect solution, deal with the fact that you're probably not going to get there.
I understand what compromises are. What I don't understand is what Brandie expects to gain by adding an IDENTITY column at the end of a unique clustered index. I'd hoped she might care to explain that.