SQL Server 2019 |SQL Server Network Configuration | Named Instances, ports and protocols

SQL Server 2019 |SQL Server Network Configuration | Named Instances, ports and protocols
ALTER SERVER CONFIGURATION
Modifies global configuration settings for the current server in SQL Server.
Limitations and Restrictions
This statement doesn't support DDL triggers.ALTER SETTINGS permissions for the process affinity option.ALTER SETTINGS and VIEW SERVER STATE permissions for the diagnostic log and failover cluster property options.CONTROL SERVER permission for the HADR cluster context option.
ALTER SERVER STATE permission for the buffer pool extension option.
Examples
Start diagnostic logging
ALTER SERVER CONFIGURATION SET DIAGNOSTICS LOG ON;
Stop diagnostic logging
ALTER SERVER CONFIGURATION SET DIAGNOSTICS LOG OFF;
Enable all In-Memory Database features with default options
ALTER SERVER CONFIGURATION SET MEMORY_OPTIMIZED ON;
GO
Enable memory-optimized tempdb metadata with a user-defined resource pool
ALTER SERVER CONFIGURATION SET MEMORY_OPTIMIZED TEMPDB_METADATA = ON (RESOURCE_POOL = 'pool_name');
GO
Alter Database Scoped Configuration
This command enables several database configuration settings at the individual database level.Clear procedure cache.
Set the query optimizer cardinality estimation model independent of the database to compatibility level.Enable or disable parameter sniffing at the database level.Enable or disable query optimization hotfixes at the database level.Enable or disable the identity cache at the database level.
Enable or disable collection of execution statistics for natively compiled Transact-SQL modules.
Permissions
Requires ALTER ANY DATABASE SCOPED CONFIGURATION on the database. This permission can be granted by a user with CONTROL permission on a database.
SQL Server 2019, SQL Server 2019 Configuration,
Alter Database Scoped Configuration in SQL Server, SQL Syntax,
SQL Server Instance and Database Configuration
sql server 2019,sql server,sql server instance and database configuration,sql server instance,sql server management studio,microsoft sql server,sql server configuration manager,sql server 2019 configuration,sql server instance configuration,sql server 2019 features,ms sql server 2019
To learn latest technology online, visit https://www.skillpedia.co

• #education
• #sql_server_2019
• #sql_server_2019_configuration
• #alter_database_scoped_configuration_in_sql_server
• #sql_syntax
• #sql_server_instance_and_database_configuration
• #sql_server_2019
• #sql_server
• #sql_server_instance_and_database_configuration
• #sql_server_instance
• #sql_server_management_studio
• #microsoft_sql_server
• #sql_server_configuration_manager
• #sql_server_2019_configuration
• #sql_server_instance_configuration
• #sql_server_2019_features
• #ms_sql_server_2019