Tapahtumat
31. maalisk. klo 23 - 2. huhtik. klo 23
Suurin SQL-, Fabric- ja Power BI -oppimistapahtuma. 31. maaliskuuta – 2. huhtikuuta. Käytä koodia FABINSIDER säästääksesi 400 dollaria.
Rekisteröidy jo tänäänsys.database_scoped_configurations (Transact-SQL)
Applies to: 
SQL Server 2016 (13.x) and later versions
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
SQL database in Microsoft Fabric
Contains one row per configuration.
| Column name | Data type | Description |
|---|---|---|
| configuration_id | int | ID of the configuration option. |
| name | nvarchar(60) | The name of the configuration option. For information about the possible configurations, see ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL). |
| value | sqlvariant | The value set for this configuration option for the primary replica. |
| value_for_secondary | sqlvariant | The value set for this configuration option for the secondary replicas. |
| is_value_default | bit | Specifies whether the value set is the default value. Added in SQL Server 2017. |
Requires membership in the public role.
When NULL is returned as the value for value_for_secondary, this means that the secondary is set to PRIMARY.
Database scoped configuration settings will be carried over with the database. This means that when a given database is restored or attached, the existing configuration settings remain.
Lisäresursseja
Opetus
Moduuli
Configure databases for optimal performance - Training
Configure databases for optimal performance
Sertifiointi
Microsoft-sertifiointi: Azure-tietokannan järjestelmänvalvojan kumppani - Certifications
Hallitse SQL Server -tietokantainfrastruktuuria pilvipalveluissa, paikallisissa tietokannoissa ja hybridirelaatiotietokannoissa Microsoft PaaS -relaatiotietokantatarjonnan avulla.
Ohjeet
-
ALTER DATABASE SCOPED CONFIGURATION - SQL Server (Transact-SQL)
Enable several database configuration settings at the individual database level.
-
Degree of parallelism (DOP) feedback - SQL Server
Learn about Degree of parallelism (DOP) feedback, part of the Intelligent Query Processing (IQP) feature set.
-
Interoperability issues between batch mode processing and large page memory model - SQL Server
Learn to resolve the performance and stability issues that that arise from the use of batch mode processing on columnstore and rowstore with large page memory model in SQL Server.