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

SQL Server Denali – Sequences

The latest installment of Microsoft’s SQL Server database management system, codenamed Denali, is in the community technology preview stage, where it is available to developers for review. Among the numerous new features of what will presumably eventually become SQL Server … Read More