I was recently looking at some Execution Plans with a co-worker and we ended up discussing the different types of joins in a SQL Server and what implications they might have when it comes to query performance. While many of us are familiar with writing joins, as we usually don’t query just a single table, there are quite few things about the physical joins that may not quite obvious. In this post our focus will be in the physical joins, but we will also very briefly look at the different types of logical joins also.
This year I didn’t write my usual daily blog posts during the PASS Summit 2016 as I felt it to be bit too much work with the long days and bit of a jet lag with the 10 hour time difference. Instead I decided to write a post summarizing my experience of the event. Every year, when deciding on what pre-con sessions to take and what regular sessions to attend to I try to think of a theme. This year I decided to go with Big Data and Analytics, as that’s an area of Microsoft Data Platform I’m not terribly familiar with. It was also a good choice because with SQL Server 2016 we’re seeing a huge number of improvements on technologies involved with these topics and there were quite a few sessions regarding these.