CLR triggers the garbage collection when one of the following event occurs :
- GC.Collect() Method is called explicitly by code.
- Windows reporting low memory condition via Win32 notification.
- When CLR Unloads the AppDomain.
- When CLR is shutting down.
Month: January 2017
Parse JSON Data in Sql Server 2016
Sql server allows you to parse Json data with OpenJson .
Sample Json data : [{“MinValue”:”1″,”MaxValue”:”6″}]
Parsing Json to map into Tables:
declare @metadata="[{"MinValue":"1","MaxValue":"6"}]"
select Minvalue,MaxValue from openjson(@metadata)
with (MinValue nvarchar(2),MaxValue nvarchar(2));
rangeshsripathi.com 