Primary keys and clustered indexes
Primary keys and clustered indexes are two distinct concepts that often get mixed up with one another, but it’s important to understand the difference between them in order to build robust, performant SQL databases.
Dead simple Ajax
An ESLint starter kit for React development
.eslintrc (configuration) file to get you started.
Inlining table-valued functions in SQL Server
Table valued functions in SQL Server are great for writing DRY SQL code by encapsulating commonly-used snippets of database logic. However, in some cases they can be at the root of serious performance problems. Let’s take a look at an example of this. Say that we have a table that looks like the following.