Wednesday, June 28, 2023

MS-SQL Server - TEJU - Imp. Configurations

TEJU - Imp. Configurations


- Tempdb metadata memory-optimized (A)


- External scripts enabled (SC) (RR)


- Job Configuration

https://learn.microsoft.com/en-us/sql/ssms/agent/configure-a-user-to-create-and-manage-sql-server-agent-jobs?view=sql-server-ver16


- User options


Related article...

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-configuration-options-sql-server?view=sql-server-ver16




Any query will be considered.


T. Amit Vaid S.

2 comments:

Anonymous said...

Partitioning of Particular table,
Joins,
Performance Tuning,
Replication Monitoring,
Maintenance jobs,
Materialised View,
ASYNC_OP_CONTEXT_READ,
HKCS_PARALLEL_MIGRATION,
Int. Use only

Anonymous said...

Links
Solution Explorer
https://learn.microsoft.com/en-us/sql/ssms/solution/solution-explorer?view=sql-server-ver16

Iterate through a result set by using Transact-SQL in SQL Server
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/development/iterate-through-result-set

Backup Hangs
https://support.microsoft.com/en-au/topic/kb4523102-fix-sql-server-database-remains-in-frozen-i-o-state-indefinitely-when-backed-up-by-vss-bd46bb50-2443-c3ee-fdd7-cb7d11c1b6cc

Builds
https://learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updates