Administering COTS databases (ISVs / Third Party Vendors)
I recently received a question from a vendor about databases created by software vendors.
administration
Does Adding NOINDEX Change DBCC CHECKDB with PHYSICAL_ONLY?
The NOINDEX option does change the behavior of DBCC CHECKDB (even if you’re already using PHYSICAL_ONLY). Here’s how the two options compare to one another, and how to see the difference yourself in a simple example.
Target Recovery Interval and Indirect Checkpoint - New Default of 60 Seconds in SQL Server 2016
Update, 6/21/2016: Be careful using indirect checkpoint with failover clusters if your SQL Server 2014 instance is not fully patched. See KB 3166902. This bug was fixed in SQL Server 2016 prior to RTM.
SQL Server 2016 introduces big new features, but it also includes small improvements as well. Many of these features are described in the “It Just Runs Faster” series of blog posts by Bob Ward and Bob Dorr.