SQL CLR Functions and parallelelism

If you develop your own SQLCLR functions, you know you should decorate the method with this attribute class: [MSDN] SqlFunctionAttribute Class. You might wonder what these options will do. The DataAccess Property, according to the documentation, “Indicates whether the function involves access to user data stored in the local instance of SQL Server”.  You might be…

2

Sneak peek on SQL 2014: Parallel SELECT ... INTO!

We are all exited about SQL 2014. I’m sure you have already downloaded the CTP. In this short post I would like to show you a welcome feature that you might not know about :). Suppose to have a large, parallel query. Until now if you wanted to create a table out of that query…

2