Using Daystart() function in the script causes high CPU usage? No, I haven't noticed that before.
[And I believe daystart() is a pretty simple operation and shouldn't cost much at all.]
Besides, how do you tell that it is exactely this function that causes high CPU usage?
Could you post a small sample script that demonstrate this issue?
Sorry about being late in getting back to you. Please find below the query and a screenshot of the server cpu usage. The data is a cust ID ([Customer_Raw.cust_id]) and a Date timestamp (Customer_Raw.cr_date). If you have any quereis I would be more than happy to help. Thanks very much.
LOAD [Customer_Raw.cust_id] AS %cust_id
, [Customer_Raw.cr_date] AS [Registation DateTime]
, Date(DayStart([Customer_Raw.cr_date])) AS [Registration Date]
[E:\ProgramData\Test Server Files\Temporary Work\Optimizing Scripts\Files\Customer_Raw.qvd]