Why Scalar Functions Can Be Costly

Scalar Functions are very useful in SQL Server but they need to be used correctly. You can find a simple query takes much too long to run and the only problem is that the function needs to calculate on every row returned. There are many ways to write queries and this article will show you why scalar functions can cause you headaches.