Pages

▼

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.

at

2 comments:

  1. AnonymousJune 28, 2023 at 6:29 PM

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

    ReplyDelete
  2. AnonymousJune 29, 2023 at 1:51 PM

    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

    ReplyDelete