T-SQL to set Max memory in MSSQL

 To set max memory for Microsoft SQL server, use the below Transact SQL.

USE master
EXEC sp_configure ''show advanced options'', 1
RECONFIGURE WITH OVERRIDE
GO
--To set a maximum memory limit, type the following, pressing Enter after each line:
USE master
EXEC sp_configure ''max server memory (MB)'', <MaxServerMemory>
RECONFIGURE WITH OVERRIDE
GO
--MaxServerMemory is the value of the physical memory in megabytes (MB) that you want to allocate.
--To hide the maximum memory setting, type the following, pressing Enter after each line:
USE master
EXEC sp_configure ''show advanced options'', 0
RECONFIGURE WITH OVERRIDE
GO
exit