I am reviewing some slow running processes in a data warehouse and noticed there are a few cast (column as date) conversion when joining tables in a stored procedure which feeds to the semantic layer.
I was wondering if moving these conversations to the staging layer ETLs will make any noticeable difference?
I understand converting them in the ETL is best practice and you do it only once and don't have use cast on all the other stored procedures/views/queries but I wonder if converting in the ETL is any faster than cast() function in SQL Server?