MS-SQL Server - SUM & AVG Functions

SUM & AVG Functions

https://learn.microsoft.com/en-us/sql/t-sql/functions/sum-transact-sql?view=sql-server-ver16

&

https://learn.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql?view=sql-server-ver16

Additionally,

Deep Analysis by

- WaitType Analysis

- Performance Monitor

- Index Fragmentation

- DMVs

View or change server properties

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

GRANT Database Permissions

https://learn.microsoft.com/en-us/sql/t-sql/statements/grant-database-permissions-transact-sql?view=sql-server-ver16

Installing SQL Server Native Client

https://learn.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client?view=sql-server-ver16

WaitTypes

PREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROL

QUERY_EXECUTION_INDEX_SORT_EVENT_OPEN

Internal Use only

PREEMPTIVE_UNMARSHALPROPAGATIONTOKEN

FT_IFTS_NOISE_WORDS_RESOURCE

GDMA_GET_RESOURCE_OWNER

The solution that have fixed precision and scale is called Numeric data types

https://learn.microsoft.com/en-us/sql/t-sql/data-types/decimal-and-numeric-transact-sql?view=sql-server-ver16

Day along with Date

https://learn.microsoft.com/en-us/sql/t-sql/functions/datepart-transact-sql?view=sql-server-ver16

View the Dependencies of a Table

https://learn.microsoft.com/en-us/sql/relational-databases/tables/view-the-dependencies-of-a-table?view=sql-server-ver16

The sys.dm_tran_aborted_transactions DMV shows all aborted transactions on the SQL Server instance.

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-aborted-transactions?view=sql-server-ver16

IAM and PFS Monitoring

https://techcommunity.microsoft.com/t5/sql-server-support-blog/sql-server-iam-page/ba-p/1637065

मेरा SQL Server, हमारा आदेश

Best Regards

T. Amit Vaid S.