MS-SQL Server - Color Illustration

Color Illustration

https://learn.microsoft.com/en-us/answers/questions/279400/looking-for-sql-server-2019-architecture-diagram

Year Data Type

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

Lower Function

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

Group by Clause

https://learn.microsoft.com/en-us/sql/t-sql/queries/select-group-by-transact-sql?view=sql-server-ver16

2019 Features

https://www.microsoft.com/en-in/sql-server/sql-server-2019-features

Pivot and Unpivot

https://learn.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-ver16

Foreign Key Constraint

https://learn.microsoft.com/en-us/sql/relational-databases/tables/create-foreign-key-relationships?view=sql-server-ver16

Additionally,

How do I create a balance sheet with SQL Server

https://learn.microsoft.com/en-us/answers/questions/627446/how-do-i-create-a-balance-sheet-with-sql-server

&

ALTER INDEX REORGANIZE

ALTER INDEX REBUILD

https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-index-transact-sql?view=sql-server-ver16

Best Regards

T. Amit Vaid S.