Procedural, Semi-Procedural and Declarative Programming in SQL
        Posted  
        
        on SQL Server Central
        
        See other posts from SQL Server Central
        
        
        
        Published on 2010/03/09
        Indexed on 
            2010/03/15
            15:40 UTC
        
        
        Read the original article
        Hit count: 506
        
Filed under: 
        A lot of the time, the key to making SQL databases perform well is to take a break from the keyboard and rethink the way of  approaching the problem; and rethinking in terms of a set-based declarative approach. Joe takes a simple discussion abut a problem with a UDF to illustrate the point that ingrained procedural reflexes can often prevent us from seeing simpler set-based techniques.
        
        © SQL Server Central or respective owner