2014年8月31日
Comparing Inline and Multi-Statement Table valued UDFs
摘要： refer:http://blog.waynesheffield.com/wayne/archive/2012/02/comparing-inline-and-multistatement-table-valued-functions/Table-Valued Functions. What a w... 阅读全文
posted @ 2014-08-31 19:36 Cathy Lee 阅读(5561) 评论(0) 推荐(0)
scalar UDFs performance issue
摘要： refer from InsideMiscrsoft SQL Server 2008: T-SQL Programming.You should be aware that invoking scalar UDFs in queries has a high cost when you provid... 阅读全文
posted @ 2014-08-31 17:57 Cathy Lee 阅读(255) 评论(0) 推荐(0)
INNER JOIN vs. CROSS APPLY
摘要： refer from :http://explainextended.com/2009/07/16/inner-join-vs-cross-apply/INNER JOINis the most used construct inSQL: it joins two tables together, ... 阅读全文
posted @ 2014-08-31 17:42 Cathy Lee 阅读(295) 评论(0) 推荐(0)