Warning: Constant WP_TEMP_DIR already defined in /var/www/html/blogs/joe/wp-config.php on line 93

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902
{"id":494,"date":"2012-05-24T10:50:00","date_gmt":"2012-05-24T10:50:00","guid":{"rendered":"\/blogs\/joe\/post\/Tale-of-the-Inconsistent-UDF-Logical-IOs.aspx"},"modified":"2013-01-02T20:31:56","modified_gmt":"2013-01-03T04:31:56","slug":"tale-of-the-inconsistent-udf-logical-ios","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/joe\/tale-of-the-inconsistent-udf-logical-ios\/","title":{"rendered":"Tale of the Inconsistent UDF Logical IOs"},"content":{"rendered":"

This post was motivated by an email question I got this week.<\/p>\n

Imagine you have the following scalar UDF:<\/p>\n

\n
CREATE<\/span> FUNCTION<\/span> dbo.RemoveYear (@date<\/span> datetime)<\/pre>\n
RETURNS<\/span> datetime<\/pre>\n
AS<\/span><\/pre>\n
BEGIN<\/span><\/pre>\n
    <\/pre>\n
    DECLARE<\/span> @removeyear datetime = DATEADD(year<\/span>, -1, @date<\/span>);<\/pre>\n
 <\/pre>\n
    RETURN<\/span>(@removeyear);<\/pre>\n
END<\/span>;<\/pre>\n
GO<\/pre>\n<\/div>\n