Riley Waterhouse Limited
Skip to content
  • Home
  • Blog
  • About

Tag: cte

Power and Deception of CTEs

Posted on May 14, 2012October 20, 2014 by Kev Riley

This is a reprint of an article of mine that appeared on SQLServerCentral.com in December 2008 Introduction A customer of mine had a performance problem with a stored procedure that uses Common Table Expressions (CTEs). The performance had gone from sub second to 10-12 secs, and the approach that was being taken to diagnose and Read more about Power and Deception of CTEs[…]

Posted in Database Development, SQL Server, TSQLTagged common table expressions, cteLeave a comment

Recent Posts

  • JSONTABLE – Shredding JSON data into a relational structure
  • Where is the standby file?
  • SQL Monitor Alerts in Microsoft Teams
  • New home for session content
  • Closed answer technical tests and when ‘it depends’ isn’t an option

Recent Comments

    Archives

    • January 2022
    • April 2021
    • June 2019
    • October 2018
    • September 2018
    • March 2017
    • February 2017
    • December 2016
    • October 2016
    • June 2016
    • January 2015
    • November 2014
    • October 2014
    • April 2013
    • March 2013
    • May 2012

    Categories

    • Career
    • Community
    • Database Development
    • Monitoring
    • Powershell
    • Productivity
    • SQL Server
    • SSDT
    • SSRS
    • TSQL
    • Uncategorized

    Recent Posts

    • JSONTABLE – Shredding JSON data into a relational structure
    • Where is the standby file?
    • SQL Monitor Alerts in Microsoft Teams

    Search

    Strawberry Fields Digital Hub, Euxton Lane, Chorley, Lancashire PR7 1PS
    [email protected]
    +44(0)7808721595
    • Facebook link
    • Twitter link
    • LinkedIn link

    © Riley Waterhouse Limited 2018
    Icons by icons8.com

    Zelle Lite Developed by ThemeIsle