Updating locate database

Posted by / 05-Apr-2020 07:29

Updating locate database

Applies to: SQL Server 2012 (11.x) through SQL Server 2017, Azure SQL Database The id of the resource pool that is mapped to this database.

This resource pool controls total memory available to memory-optimized tables in this database.

Indicates the default setting for the incremental option of auto stats.

NONE = legacy database (zero containment) PARTIAL = partially contained database Applies to: SQL Server 2012 (11.x) through SQL Server 2017, Azure SQL Database The delayed durability setting: 0 = DISABLED 1 = ALLOWED 2 = FORCED For more information, see Control Transaction Durability. 0 = Tables and indexes in the database always allocate initial pages from uniform extents.

Applies to: SQL Server 2014 (12.x) through SQL Server 2017, Azure SQL Database. 1 = Tables and indexes in the database can allocate initial pages from mixed extents.

Indicates whether the database honors conversation priorities (reflects the state last set by using the ALTER DATABASE SET HONOR_BROKER_PRIORITY clause).

Can be one of the following values: 1 = HONOR_BROKER_PRIORITY is ON 0 = HONOR_BROKER_PRIORITY is OFFUnique identifier of the local Always On availability groups availability replica of the availability group, if any, in which the database is participating.

updating locate database-12updating locate database-4updating locate database-80

10 = For internal use only Applies to SQL Server 2012 (11.x) through SQL Server 2017 11 = For internal use only Applies to SQL Server 2012 (11.x) through SQL Server 2017 12 = For internal use only Applies to SQL Server 2012 (11.x) through SQL Server 201713 = Oldest page Applies to SQL Server 2012 (11.x) through SQL Server 2017 14 = Other Applies to SQL Server 2012 (11.x) through SQL Server 2017 16 = XTP_CHECKPOINT (When a database uses a recovery model and has a memory-optimized data filegroup, you should expect to see the log_reuse_wait column indicate checkpoint or xtp_checkpoint.) Applies to SQL Server 2014 (12.x) through SQL Server 2017Indicates whether the database is encrypted (reflects the state last set by using the ALTER DATABASE SET ENCRYPTION clause).

One thought on “updating locate database”

  1. Happy birthday Bhumi Pednekar: Toilet: Ek Prem Katha and Dum Laga Ke Haisha actor Bhumi Pednekar hosted a celebration last night which saw Varun Dhawan, Karan Johar, Vaani Kapoor, Shashank Khaitan and a few other celebs in attendance.