Are scalar User-Defined Functions Ever a Good Idea?

Are scalar User-Defined Functions Ever a Good Idea? In SQL Server, you have the ability to create a user-defined function that can perform an operation directly inline as a part of a query. For example, consider an ordering system, which … Read More

Database Performance Tips You Won’t Want To Miss

In a data-driven web application, poor database performance can needlessly burden your server or, worse, make your website slow enough that your user gives up and goes somewhere else. So we have put together some of the common pitfalls we … Read More