-

SQL Server Indexing: Part 3 – Implementing and Testing Indexes
In part 1 of this series, we learned about the basics of indexes, what they do, and what they’re for. In part 2, we talked about query plans. We learned about reading query plans…
-

SQL Server Indexing: Part 2 – Reading Query Plans
Welcome to part 2 of SQL Server Indexing, in part 1, we learned the basics of indexes and the difference between clustered and non-clustered indexes. In this part, we’re going to learn how to…
-

SQL Server Indexing: Part 1 – Understanding Indexes
Database indexing, often the go-to solution to database performance issues, is a much more complicated than we realize at first thought. The solution to just “slap an index on the column” is not optimal,…
-

How To Work With Memory Optimized Objects in SQL Server
Good morning everyone, today I’m going to show you how to make memory optimized tables and natively compiled stored procedures. First, I’ll talk about why you might want to use these things, then we’ll…
-
Erik’s Code Space
Hello everyone, it is currently July 15th of 2019 and I’ve decided to start a blog related to the things I learn while on my journey to being the best software engineer I can…








