It is indeed true Microsoft will official support ends of the product on July 9, 2019. Comprehensive Database Performance Health Check.Â
Many times I have seen issue of SELECT 1 vs SELECT * discussed in terms of performance or readability while checking for existence of rows in table. I ran quick 4 tests about this observed that I am getting same result when used SELECT 1 and SELECT *. I think smart readers of this blog will come up the situation when SELECT 1 and SELECT * have different execution plan when used to find existence of rows.
SQL Server Management Studio is an amazing product and I am personally a big fan of the same. Here are the few latest blog written on the same subject.
The licensing structure has evolved to reflect advances in technology and diverse use cases. Below are the primary licensing models available:
This was a very old blog post and I have decided to re-write this as it was no longer useful. In this blog post, we will learn about SQL Server 2017. Here is how you can download SQL Server 2017 related material.