To be clear, I don't see this as an unorthodox way of handling so-called impedance mismatches. Indeed, there are times when one WANTS to capture properties of the RELATIONSHIP on...

I don't think of these as "super keys" per se, but rather COMPOSITE keys. Which from a database standpoint is exactly what you would do. But more importantly from a...

Brandie Tarvin (10/30/2015)

---

Eric M Russell (10/29/2015)

---

Maybe I'm missing something, but the table appears to lack a unique index on the natural key, which would allow duplicates. This would normally be...

When you open up your article with "Creating <anything> can be scary..." you've lost half your audience. Speak for yourself. I personally count it one among many privileges/duties I would...

I am not wrong to want to do something about the indication. The question is misleading if "parallelism" was all you were looking for.

This is verbatim from the MSDN: "Occurs...

The parameters criteria was my first guess as well. The OP was vague in his assumptions.

Explain the criteria you are using to differentiate the question. That is all...

Not...

Orlando Colamatteo (5/26/2015)

---

Thanks for taking the time to write the article. Given the alternatives I strongly prefer employing a SQLCLR for implementing file system access from T-SQL. However, in this...

I've done that recently as well and I would suggest probably yes it does pose a security risk. At least put controls around the continuous delivery path.

Ditto using filestrstream. Especially as it broadens support for larger files.

given the...

No, but it is bad practice not to alias the result...

Well, I stand corrected. Thank you. 🙂

It is an interesting exercise, but doesn't really accomplish anything anyone would encounter in the real world. BREAK is an interesting SQL keyword, did not know that. Also beware the...