Clustered versus Non-Clustered Indexes

Explanation courtesy of StackOverflow. With a clustered index the rows are stored physically on the disk in the same order as the index. There can therefore be only one clustered index. With a non clustered index there is a second list that has pointers to…

String Format functionality in SQL

The c# String.Format functionality is extremely helpful. Not only is the code easy to write, but also easy to read. I’ve found it difficult to write the same code in SQL. Having to concatenate strings with + symbols and be tedious. Thankfully, there is the…