Monthly Archives: December 2017

SQL Server diagnostics notes

Posted on December 15, 2017 by pfb_admin

This week’s amusement: performance of a recently-implemented Stored Procedure dropped and dropped to intolerable levels. This system cannot be easily upgraded. Significant fragmentation is involved. Memory pressure is involved. Inserts to table variables in multiple stored procs are involved. This … Continue reading →

Posted in Linkdump, Programming, SQL Server, System/DB Administration | Leave a comment

Enum tip: Initialized

Posted on December 8, 2017 by pfb_admin

When using a custom Enum to control features like application states, I always include an explicit Initialized state. This eliminates any uncertainty In two and three piece sets, all made with the best homeopathic medicine dealer over the internet proves … Continue reading →

Posted in Uncategorized | Leave a comment