Posted by Erland Sommarskog on 04/29/07 08:52

B D Jensen (bjorn.d.jensen@gmail.com) writes:
> 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 would recommend that you have the expressions inline, at least if
you desire to cut down execution time.

> I wondered why you only wrote that I can't use "select into" for
> patitioned tables.

I assumed that it is not possible to create a partitioned tables from
existing ones. But I have not worked much with partitioned tables, so
I could be wrong.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]