bradsruminations.blogspot.com
SELECT Blog FROM Brad.Schulz CROSS APPLY SQL.Server(): Invitation for T-SQL Tuesday #024: Prox ‘n’ Funx
http://bradsruminations.blogspot.com/2011/10/invitation-for-t-sql-tuesday-024-prox-n.html
SELECT Blog FROM Brad.Schulz CROSS APPLY SQL.Server(). Thoughts, Musings, Ruminations, and Brainstorms on SQL and Perhaps Other Topics. Monday, October 31, 2011. Invitation for T-SQL Tuesday #024: Prox ‘n’ Funx. Boy, time really flies, doesn’t it? It’s hard to believe, but we are finishing up our second year. Started the whole concept back in November 2009 with T-SQL Tuesday #001, and here we are already up to #024. So, without further ado…. And on and on and on…. Now for those nasty rules:. I have to ad...
bartduncansql.wordpress.com
Don’t depend on expression short circuiting in T-SQL (not even with CASE) | Bart Duncan's SQL Blog
https://bartduncansql.wordpress.com/2011/03/03/dont-depend-on-expression-short-circuiting-in-t-sql-not-even-with-case
Bart Duncan's SQL Blog. Microsoft SQL Server performance, query tuning, and other topics. Living with SQL’s 900 Byte Index Key Length Limit. Row Goals Gone Rogue →. Don’t depend on expression short circuiting in T-SQL (not even with CASE). March 3, 2011. There are a fair number of blog posts and forum discussions regarding expression short circuiting in T-SQL. Some of the most authoritative posts, like this one. WHERE (@value = 0) OR ( col1 / @value) = 2). ALTER FUNCTION dbo.test case short circuit (...
SOCIAL ENGAGEMENT