Great lesson and something one would not even think about.Suggestion to
change code @line 21 to
:STRING_AGG(CONVERT(VARCHAR(max),sc1.StatisticName),'', '') WITHIN GROUP
(ORDER BY sc1.StatisticName) AS StatisticsNames,This will prevent error
when the comma delimeted statistics names exceed 8000 chara...
Hi, I'm facing a high CPU consumption on Named Replica, does rebuilding
indexes and update statistics for the primary database also execute on a
named replica?
@FonsecaSergio great article! we have intermittent issues with on-prem
VM to SQL PE by using Azure DNS private resolver. can this article be
updated with some best practices for trouble shooting with the Azure DNS
private resolver architecture?
Any idea what determines that size? I ran into the same issue with Azure
Data Studio and it seemed like a WTF. Microsoft's own tool can't figure
out the min size when it's creating the event session?
Latest Comments