You are here

MSDN Blogs

Subscribe to MSDN Blogs feed
Get the latest information, insights, announcements, and news from Microsoft experts and developers in the MSDN blogs.
Updated: 23 min 33 sec ago

Index Usage DMV behavior updated

Mon, 03/07/2016 - 11:13

Up until SQL Server 2008 R2, using  index usage stats entries in sys.dm_db_index_usage_stats to make some assumptions over index design and workload patterns was common.

However, in SQL Server 2012 and higher versions, entries in this DMV were reset with every index rebuild, so this was no longer a viable way of tracking index usage patterns. This was clearly voiced out in Connect items, such as 739566 and direct customer feedback.

In SQL Server 2016 (starting with RC0), we are restoring the expected behavior with usage stats tracking in sys.dm_db_index_usage_stats, where entries will not be removed. This was documented in What's New in Database Engine.

We are also addressing this in an upcoming SQL Server 2014 Service Pack, and as usual deliver added value to in-market versions.

Pedro Lopes (@sqlpto) – Senior Program Manager

3/7 - Errata added for [MS-WCCE]: Windows Client Certificate Enrollment Protocol

Mon, 03/07/2016 - 11:04

Changes in two sections to remove unreferenced error codes from  a table, add a missing code - 0x8007000D ERROR_INVALID_DATA – and revise the description of error code ERROR_INVALID_DATA:

3/7 - Errata added for [MS-CSRA]: Certificate Services Remote Administration Protocol

Mon, 03/07/2016 - 10:58

Two changes at

In Section, ICertAdminD::BackupPrepare  (Opnum 20), revised the description for pwszBackupAnnotation.

In Section 2.2.5, Common Error Codes, obsolete errors  codes, 0x80004003 and 0xc800020D, were removed from the error code table.

3/7 - Errata added for [MS-GPPREF]: Group Policy: Preferences Extension Data Structure

Mon, 03/07/2016 - 10:40

Changed the title to reflect that the registry keys described in the table in Section apply to both Internet Explorer 10 and Internet Explorer 11:

Using the new Google Cloud Vision API from Universal Windows Platform (UWP) Apps

Mon, 03/07/2016 - 10:32
Did you ever think about making your software smarter and detect people, objects and even landmarks in images with the same level of quality Google can? Now you can do exactly that. As you might have seen Google recently released the Beta of their Cloud Vision API and opened it up for all developers to try. The API features services for object / landmark detection, inappropriate content detection, sentiment analysis, text extraction and more. As I wanted to try the API and compare it to the great...(read more)


Drupal 7 Appliance - Powered by TurnKey Linux