To free up the procedure cache on the SQL Azure database use the following ALTER DB Statement,
ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE_CACHE;
This is same as running DBCC FREEPROCCACHE in the on-Premise SQL Instance.
ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE_CACHE;
This is same as running DBCC FREEPROCCACHE in the on-Premise SQL Instance.
Amazing Article, Really useful information to all So, I hope you will share more information to be check and share here.
ReplyDeleteinplant training
inplant training chennai
inplant training in chennai
inplant training at chennai
inplant training
inplant training chennai
inplant training in chennai
inplant training at chennai
inplant training
Inplant Training for cse