MS-SQL Server - Materialised View & MTA

MS-SQL Server - Materialised View

 

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-materialized-view-as-select-transact-sql?view=azure-sqldw-latest

Additionally,

This is to inform that below certification has now been discontinued, but you can still check with Microsoft to confirm the same.

Microsoft Technology Associate (MTA) certification

https://learn.microsoft.com/en-us/certifications/mta-database-fundamentals/

1 GB = 1024 MB
13 MB = 31,744 KB
20200KB= 19.726 MB

 

Sign Function / Feature

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

Note- Signature looks Heavy only when amount is high :).

Best Regards

T. Amit Vaid S.