Pragmatic Programmer

https://stackoverflow.com/a/1527249 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion Add: DWORD ForceLog set value to 1 DWORD LogFailures set value to 1 DWORD LogResourceBinds set value to 1 DWORD EnableLog set value to 1 String LogPath set value to folder for logs (e.g. C:\FusionLog\)

SELECT i.name, s.* FROM sys.dm_db_index_usage_stats s inner join sys.indexes i on i.object_id = s.object_id and i.index_id = s.index_id where s.object_id = Object_id('WACORe_Main.dbo.TB_Main_appointment'); https://blogs.msdn.microsoft.com/sqlserverstorageengine/2007/04/20/how-can-you-tell-if-an-index-is-being-used/

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using NLog; using NLog.Config; using NLog.Targets; namespace NLogger {     class Program     {         static void Main(string[] args)         {             var config = new LoggingConfiguration();             var consoleTarget = new ColoredConsoleTarget("Console");             var fileTarget1 = new FileTarget("File1");             var fileTarget2 = new FileTarget("File2");              config.AddTarget(consoleTarget);             config.AddTarget(fileTarget1);             config.AddTarget(fileTarget2);             consoleTarget.Layout = @"${date:fo...