Just thinking this is a good topic for a blog, rather a gallery item, However its very informative post, thanks
Is it possible to partition a table using 2 columns instead of only 1 for the partition function?
It is not possible to do using more than a column. But can use the combination of two.
What is the difference between Scalar-valued and Table Valued Functions in sql server?
Scalar functions, inlining, and performance: An entertaining title for a boring post. In this article, Adam contrasts the performance of a scalar UDF against that of a table-valued UDF for a common purpose – retrieving the MAX OrderQty from AdventureWorks.
Sales.SalesOrde rDetail for a given ProductID. He goes on to explain that the optimizer doesn’t expand scalar functions nearly as well as it does table valued functions, hence the difference in performance.