Often, when asked how I change the appearance of data, such as dates or people's names, I describe that as using smoke and mirrors. I had to be more...

Thanks for the clarification. That's pretty handy.

Thanks for this concise summary.

I note that you suggest using complex keys for the non-clustered indexes. Would I be correct in assuming that, in order for SQL to use...

I think using personal networks can be very helpful. However, there are two significant drawbacks. One is that, unless you have an extraordinarily large network, you really limit your...