Thanks for the humor in it too.

BrainDonor (9/16/2016)

---

They are defaults within Tools/Options/SQL Server Object Explorer/Commands (in SSMS 2014 -...

I've run up against this one multiple times.

Wish this was available in 2008.

I hated statistics in college (though my degree was in Math) and now I find myself a "data scientist." How ironic.

Nifty script, thanks.

Interesting article. I wasn't aware it even existed.

Carlo Romagnano (9/15/2016)

---

The correct answer is "Depends", if the view returns or not a row:

No row returned: -> The row is not updated and no error is returned.

Row returned: ->...

When I tried it, it did not update and I did get an error. This was on 2008R2. So either they quit providing the error on newer versions of sql...

Magnus Ahlkvist (9/15/2016)

---

I don't Think the correct answer is correct.

When I try to update a view (defined using WITH CHECK OPTION) with a value which makes the row fall outside...

This may be useful as we have a few wide-row tables.

Me as well.

Jeff Moden (9/14/2016)

---

Night? Free brainstorming for the company and it's at night?

I've heard of "Down Tools" or "Down Weeks" before...

ChrisM@Work (9/15/2016)

---

Interesting. It does a lot of work for the result. Have you speed-tested it against the house splitter?

Here's one I knocked up in a couple of minutes to...

Thanks for the great article in this series. I like the semi joins.