April 9, 2012 at 11:45 am
to do "table partitioning on persisted computed column referencing scalar function" you have to use schemabinding while creating scalar function that is referenced in the definition of the computed column, otherwise you may not persist it, nor partition on it.
This effectively prevents any further changes to the function; but that is one of the requirements that I have, namely adding new partitions indirectly through this scalar functions 🙁
Do you know of a way to overcome this problem ??
April 9, 2012 at 12:16 pm
I don't know that I would call this a problem. In order to have a persisted column that uses a scalar function the function must be deterministic, hence the reason you have make the function schema bound.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply