Posted by B D Jensen on 04/29/07 04:01

>
> Exactly what is in those functions? Do they perform data access? Are
> they written in T-SQL or in the CLR? I ask, because they could have a
> great impact on performance.
>

Hello Erland!
Functions are written in T-SQL (i also wrote them in CLR, but in this
case they were slower). The original columns have incorrect datatypes,
that uses too much storage,
so the functions check that values are in correct domain and if not
they return null
- what is a correct result, because the values then are physical
impossible.

I wondered why you only wrote that I can't use "select into" for
patitioned tables.
I also expected I must create table first (and then not being able to
use 'select into')
because of the new datatypes - but of course I could write:
select id, cast(func1(col1) as <datatype>) into newtbl from oldtbl

Doing this multiple times with the appropiate where-clause
followed by partion switches maybe will be the solution; I'll
investigate...

.... but if you have some comments let me hear ;-)


Greetings
Bjorn D. Jensen
bjorn.d.jensen@gmail.com


P.S. I already know your website, thanks for all that good
information!

[Back to original message]