Home Forums SQL Server 2014 Development - SQL Server 2014 Simple SQL challenge - who can solve RE: Simple SQL challenge - who can solve

  • May 13, 2016 at 10:30 pm

    #1879077

    Eirikur Eiriksson (5/13/2016)

    TheSQLGuru (5/11/2016)

    Alan.B: You have escaped the primary performance problem of chewing through unnecessary rows of each month on the date dim table with the filtered index. Well done. That was a nice trick - something I have not seen done before. That's a phrase I don't utter very often in SQL Server land! 😀

    Things like Alan's trick makes it so much worth while attending to this site, mind you not the first time he comes up with a cleaver solution.

    😎

    Thanks you Eirikur 😎

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001