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: