Pluralsight Applying SQL Server 2016 Features to Real-world Data Problems

From Minor Miracle Software
Revision as of 18:52, 11 July 2018 by WikiSysop (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Ana Voicu, www.sqlbythebook.com

What is the next big thing? Data is the new oil.


  • Query Data Store

Some queries perform better 80%, others worse, 20%. Watch for the worse performers.

Audit the history of query plans. Multiple plans can be kept for a query. Comparing them can indicate performance improvements.

Force use of old query plans. "Use the old one, no matter what."

Analyze workload patterns.

Records performance data on query plans.

Not on by default. Must be enabled with an ALTER DB command.

UI and query window.

A Query Store folder appears under the database folder.

Enable "Live Query Statistics"

  • JSON Support built in.

OPENJSON - is available only at the 130 compatibility level. "Freshly out of the oven." With all the new and unknown bugs and glitches that come with any new technology implementation.







Internal Links

Parent Article: Microsoft Certified Solutions Associate (MCSA) (SQL 2016)