Lots of people are worried that SQL Server 2008 and SQL Server 2008 R2 will not be supported after July 9, 2019. It is indeed true Microsoft will end the official support of the product on July 9, 2019. However, the good thing is that even though Microsoft ends support of the product, trust me there are many experts like me who will support the SQL Server 2008 R2.
Here is my another blog post about SQL SERVER 2008 R2 – I Support You Beyond July 9, 2019.
One of my clients is primarily using SQL Server 2008 R2 for most of their application. They are also using the same for their own clients and are managing over 100 installations of various versions of SQL Server. They have frequently hired me for Comprehensive Database Performance Health Check for their server and I must accept their business is nearly 10% of my total business. They recently reached out to me with the following email. Let us read it together.
Here is a few additional blog post on the same topic.
Which is Optimal – TOP 0 OR WHERE 1 = 2? – Interview Question of the Week #190
Question: Which is Optimal – TOP 0 OR WHERE 1 = 2?
Answer: They both are the same!
How to Write Errors in Error Log? – Interview Question of the Week #175
Question: How to Write Errors in Error Log?
Answer: This question was asked by one of my customers during SQL Server Performance Tuning Practical Workshop. The workshop is really fun as during the workshop we usually discuss quite lots of things along with SQL Server Performance Tuning subjects.
What is Lock Pages In Memory? – Interview Question of the Week #186
Question: What is Lock Pages In Memory?
Answer: When enabled, it allows accounts to keep data in physical memory, instead of paging it to virtual memory on disk.
Reference: Pinal Dave (https://blog.sqlauthority.com)