That's why I don't want to demo every feature. I can cover that in an hour, but if I...

Grant Fritchey (8/25/2016)

---

GilaMonster (8/25/2016)

---

If you were to attend a keynote presentation on "New features of SQL 2016", would you prefer brief demos of each new feature? Just discussion, along with...

Neither, I...

If you were to attend a keynote presentation on "New features of SQL 2016", would you prefer brief demos of each new feature? Just discussion, along with code/screenshots on slides,...

A few of them? I don't think a single one is correct.

Yup, included columns are part of the index, just like key columns.

Any query that returns the key columns should return the include columns as well, unless they're getting explicitly filtered...

This method is about the only way to do it, unless you...

That blog post is wrong in a few places.

This, for example, is wrong.

Bulk logged recovery model performs much better than simple logged recovery model because it uses minimal log space...

And be warned that such a constraint doesn't work properly. If, for example, you put a constraint using a scalar udf like that on the TOOL_SET table, it only gets...

Yes. It works fine with ad-hoc, prepared or stored procedures.

johnwalker10 (8/24/2016)

---

If you have any idea when this occured, you could take a look at agent's log file to see if anything bad happened. It's in a file called SQLAGENT.OUT,...

If you specify SORT_IN_TEMPDB = on for an index CREATE or ALTER, then that CREATE or ALTER will sort in TempDB. If you do not specify it for an index...

Upgrade advisor doesn't import databases. It just checks for possible problems that the DB will have on the new version (using removed features, etc).

Backup/restore is how we normally get...

What statement did you run to get that?

What state is the database in? (Online, suspect, recovery pending)

You are correct. For some reason I was thinking int = 8 when I wrote that.