Thanks for your contribution, however you skipped/forgot Step3 and although it's stated in the title of the Step4, there's no a CREATE PARTITION SCHEME script under that item.
--Step 3 : Create partition scheme CREATE PARTITION SCHEME TestDB_Partitio
nScheme AS PARTITION TestDB_Partitio nRange TO ([Primary],Test DB_Part2) go
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.