MS-SQL Server - Server Roles

Server Roles

https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles?view=sql-server-ver16

In addition to this please also read about below topics,
In Disk, Perfmon Counters & Raid Recommendations, Gam Allocation, Lock:Deadlock Chain, Hostname Filter by Profiler Trace, Capitalize all letters BY UPPER Function.

Recommendations to reduce allocation contention in SQL Server tempdb database

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/recommendations-reduce-allocation-contention

UPPER()
https://learn.microsoft.com/en-us/sql/t-sql/functions/upper-transact-sql?view=sql-server-ver16

SQL Server Architecture में सबका ध्यान सिर्फ logical design पर जाता है, जबकि हमें उसके physical allocation को समझना भी जरूरी होता है,

Additionally,

Arguments
PAD_INDEX = { ON | OFF }
Applies to: SQL Server 2008 (10.0.x) and later.

Specifies index padding. The default is OFF.

ON
The percentage of free space that is specified by FILLFACTOR is applied to the intermediate-level pages of the index.

OFF or fillfactor is not specified
The intermediate-level pages are filled to near capacity, leaving enough space for at least one row of the maximum size the index can have, given the set of keys on the intermediate pages.

Imp.Waitypes

DEADLOCK_ENUM_MUTEX
DEADLOCK_TASK_SEARCH
OLEDB
SECURITY_MUTEX

OS Wait Types में भी जरूरत के सभी waitypes already अलग से दिए हुए हैं!

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-wait-stats-transact-sql?view=sql-server-ver16

https://amit-sqldbasupport.blogspot.com/2022/12/sql-server-max-options.html?m=1

Best Regards

T. Amit Vaid S.