C Sharp Method Group Conversions

// The following is a simple example of event handlers without having to declare new’s 

using System;

namespace DelegateConsole
{
    public class SimpleMaths
    {
        public delegate void MathsMessage(string msg);
        public event MathsMessage ComputationFinished;

        public int Add(int x, int y)
        {
            ComputationFinished(“Adding Complete”);
            return x + y;
        }
        public int Subtract(int x, int y)
        {
            ComputationFinished(“Subtracting Complete”);
            return x – y;       
        }
    }

    class Program
    {
        static void Main(string[] args)
        {
            SimpleMaths s = new SimpleMaths();
            // Method group conversion – almost a delphi event handler
            s.ComputationFinished += ComputationFinishedHandler;
            Console.WriteLine(“10 + 10 is {0}”,s.Add(10,10));
            Console.ReadLine();
        }

        static void ComputationFinishedHandler(string msg)
        {
            Console.WriteLine(msg);
        }
    }
}

SQL Server performance problem

This is a link to a SQL Server sp4 problem and a suggested soltion.

SQL Server sp3 had a bug in which indexes with non-integer numeric values could miss values in a select – especially when comparing differing precision.

The solution that they implemented can result in table scans – causing a huge performance penalty in areas that were unaffected by the problem. I known that missing data is bad – but forcing table scans is a rather severe penalty.