Ah - that was my bad. Didn't realise how old the original post was, since it was only a few posts down from the top.

I kinda feel like...

Drew, can you explain that query a bit more? I've never seen that type of operation before. What exactly is the CROSS APPLY doing in this case? And how does...

What you're doing is a CROSS JOIN, just without using the words CROSS JOIN.

By specifying two tables with a comma, SQL Server is implicitly applying a CROSS JOIN to...

Another thing you might want to consider for these kind of operations, especially if they are ones that you plan on repeating often, is to move towards SQL Server Integration...

Thanks Jeff - I'll take a look at your suggestions.

But as to my original question, I guess your answer is, there isn't any real built-in way of enforcing referential...

Hi guys,

Not usually one to bump a thread, but this same topic came up again when I was doing some database design, and was hoping maybe someone had...

Hey Grant,

I'm sure you've worked on some large-scale projects. My main concern with the idea you've suggested is that it seems to not be consistent across the board....

Regarding point #1, I'm not really sure I follow. In what way do they affect performance, if they are not being retrieved by queries? Are you suggesting that just the...